Running the work flow with same data in multiple outputs

chinnaupendra07

So let say I have a Excel file with data given so i need to copy same data with multiple file should create in the folder with different files name but when i run the workflow the output should be same data with another file name that's my quary of the day .

VijayAnaparthi

Hi Upendra,

Below are the steps you can follow to get new file everytime you run with different file name.

Step 1 - Take directory tool and and add folder path.

Step 2 - Take filter and configuration of filter tool is like where Contains(FileName, 'Test.xlsx'(Let's say file name is Test.xlsx.

Step 3 - Count number of Rows that is coming from True anchor of filter tool.

Step 4 - Join both True anchor tool and count output by using join multiple tool on record position.

Step 5 - Use sort tool to Descending order of Count column.

Step 6 - Use sample tool to pick 1st row only.

Step 7 - You need to use Formula tool, where you need to add the logic that i attached as image. In my case Data is sheet name.

Step 8 - Then use Dynamic input tool and Use change entire filepath as configuration and use Fullpath column as filed.

Step 9- Take only New_Filename column from step 7 formula tool output.

Step 10 - Join Step 8 and step 9 output by using join multiple to on record position.

Step 11 - Finally use output tool, configuration as Change entire file path and field you have to pass New_FileName there.

Now everytime you run workflow it will produce new file with different filename and same data. It looks like Test.xlsx, Test_2.xlsx, Test_3.xlsx ---- etc.