How to input the outputted files in the same workflow and upload using Powershell script

Pankhudri20

Hello,

I am looking to upload the files created in my workflow.

The output tool creates multiple excel files. I then input them using dynamic input and run the script to upload.

However, it is writing all the records in the batch file instead of excel files.

Can anyone please tell me how to resolve this?

I am really stuck at this point and it is urgent to resolve this.

Any help would be greatly appreciated.

It writes 194252 records to the batch file.

But it should write only the 6 files to batch file.

number of files created is dynamic. It is an automated workflow which runs every monthly fiscal period and creates weekly files for that period. These files need to be uploaded using the command.

Thank you

Regards,

Pankhudri

T_Willins

@Pankhudri20 

Why do the files need to be brought back into the workflow to upload them using the command function.  Please advise if I am incorrect, but it looks like you are trying to create 1 or more .CSV files, then use the Run Command tool to upload those files.  Instead of bringing in the files with the Dynamic Input, try extracting the relevant filepath information using a Summarize tool (where the Dynamic Input tool is now) using Group By CSV name, update the filepath using the Fomula tool as you do now, and keep the Select tool and Run Command tool as they are currently configured.  This should reduce the number of rows only to the number of output files (6 in your example) that are read to the Run Command tool. Let me know if this works or we can troubleshoot further.