Dynamically selecting row

MK-Annalect

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

atcodedog05

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 🙂

file path.yxmd