To add date on top of the output

[R731990]

Hello,

I have one mapping file where everyday will update the date for which workflow will be run. I want to update that date in my output at top of the table.

I tried using todays formula, but that will give me todays date every time but it is not mandatory that i am running the file for today or always T-1, it can be any day thus have created mapping file to update date, but how i will get that date on the top of my output?

Thanks in advance,

Nitu

[binuacs]

@R731990 One option extract the date from the mapping file and append it to the original file

[caltang]

Using @binuacs solution will get you what you want. Otherwise, you can add a text box, and append it to your data - then convert your workflow to an Analytic App with the Date Interface tool added, thereby granting you ultimate flexibility in choosing any date.

Hope this helps!!

[caltang]

@R731990 did the above solve your need? Kindly mark as accepted solution to close the thread. Thanks!

[R731990]

Hi, i dont want to change anything in workflow after it is created. Thus cant convert it into analytical app. so need to use the mapping file for date and that date needs to be picked up by alteryx whether on top of output or as the name of sheet of output file.