One Output File

[VSha]

Hello,

My Alteryx query seems to be splitting out my output results to several files. There are 18,000+ records in total. Is there a way I can output the results to one file?

Thank you

[atcodedog05]

Hi @VSha 

Make sure Take filename from field is unchecked (below highlighted)

Hope this helps : )

[danilang · Accepted solution]

Hi @VSha 

By default, Alteryx will not split records between files.  You have to explicitly build your workflow to have to output to multiple files.  Can you post your workflow?

Dan

[VSha]

The Query is very big. These are the values selected for output.

[VSha]

[VSha]

I need this to add file date to file name.

[danilang · Accepted solution]

Hi @VSha 

If your workflow is very large, DateTimeNow() can give you different values for different records depending on when they are processed.  Use DateTimeStart() instead, which will give you the time the workflow started running as opposed to the current time

Dan 

[VSha]

Danilang, that has done the job. Thank you very much. 🙂