Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  How to out put BRD or Excel file its name with brainscript custom date parameters?

    Employee
    Posted 08-02-2017 09:36

    When I set up the parameter as year(date()) + "-" + month(date()) named year_month from Graph > Edit Parameters, it should output file name of the BRD file or the Excel file with the date format CCYY-MM, but it omit file name as a raw text like, year(date()) + "-" + month(date()) instead of that.

    When I check using a filter node, it exports without any issue. 

     

    Does anyone know how to resolve this issue?

     

    Thank you,

     

    dice



  • 2.  RE: How to out put BRD or Excel file its name with brainscript custom date parameters?

    Employee
    Posted 08-02-2017 09:41

    At this time, neither LAE nor Dataverse support using expressions to create file names.

    My common solution for this is to write out the file with some name like MyExcel_Temp.xlsx
    and then use moveFile(oldname,newname) in a filter node to rename the file.

    [code]
    oldname="MyExcel_Temp.xlsx"
    newname="MyExcel_"+year(date()).str() + "-" + month(date()).str()+".xlsx"
    moveFile(oldname,newname)
    [/code]