Data360 Analyze

 View Only

Provide Input values as Run Paramater

  • 1.  Provide Input values as Run Paramater

    Posted 05-20-2022 06:07

    I have a Doubt that ,suppose the input connects to the Output Excel Node as I_MONTH as 05, I_CYCLE as 02,I_DAY as 25 and some more fields with many records.

    i want to generate a report with all other fields with all records except only 3 fields mentioned above.(means i don't need above fields in report , the use of above field is only to specify the report name.)

    I need the output excel name as SALES_cycle02Month05Day25.xls.

    do we have any precision to do or we can only do by using run parameter. like

    SALES_cycle{{^I_CYCLE^}}Month{{^I_MONTH^}}Day{{^I_DAY^}}.xls.

    BUT we can't declare these fields as run param(values getting from query).

    Please suggest !!