Hi All,
I have the data as below. I want to design a workflow which can select one row and output it in a separate xlsx file.
For Eg - First, should select row 1 and output the file mentioned in the Path column. Similarly after that should select row 2 and output the file to the path mentioned in row 2.
Please help
Regards,
Mustafa Kanchwala
Hi @MK-Annalect
Here is how you can do it. You need create a column filename which has file path, file name, sheet (if present) and configure output tool to change path on this file name column.
Workflow:
To setup the output tool you need to first select a file to output too then you change path to %temp%
Hope this helps 🙂