Dynamic file write location
I have approx 20 separate table writer nodes all with different data.
I have 3 separate possible folder locations that the data could go to based on my selection.
So one run I may write all tables to C:\DATA_FOLDER\Knime\FOLDER_LOCATION_1\FILE_1 and then next time write all the same tables to C:\DATA_FOLDER\Knime\FOLDER_LOCATION_2\FILE_1
I want to select the folder location I want and then the path for writing the tables is dynamically updated to my folder selection
So if I select path 1 each of the 20 separate nodes with their specific file name would write to that location dynamically.
My guess would be to use Table Row to Variable and String to Path, but can’t seem to get that to work.
Any suggestions?