Variable Table Read / Write Destination folders AND a Loop

[Unlockedata]

Hi,

Looking for some assistance is someone can spare the time.

I have a workflow that I want to be driven by variables because the workflow works today, but is cumbersome to alter.

At the beginning of the workflow I want to stipulate the folder based on a rule. For example, if “student” write to c:\student\student.table, if “teacher” write to c:\teacher\teacher.table.

As a part of the workflow I have a loop that reads, appends and writes to tables.

I have the two workflow features working separately, but I’m struggling to integrate both. Hopefully the image below helps paint a better picture.

Any ideas on how I can pass the folder destination to the Reader node and incorporate the Reader know in the loop?

Thanks for any help.

[elsamuel]

Why not connect the Table Row to Variable Loop start node to the Table Reader node?

[mlauber71]

@Unlockedata maybe you take a look path this example:

Write multiple CSV file to a loop

@VJAM the creation of Flow Variables for Paths is maybe not 100% straightforward. Maybe this example might help to sort it out. The “path_values” is maybe not perfectly named. I think this is constructed that you could pass several Folder variables as collection strings. Also: CHunk Loop Start might have to be set to 1. Often I prefer the Table Row to Variable Loop Start node. [image] [image]

CSV Chunk write - create path variables – mlauber71

[Unlockedata]

@mlauber71 and @elsamuel, thank you for your comments and help.

All sorted - thanks!