Hi,
I am designing a batch macro to aggregate several CSV files into one single Database.
However my inputs don't have a set number of columns, as some sub identifier can vary from 5 to 8 identifiers each stored in different columns.
I am trying to create a conditional detour to check if the columns 5, 6, 7, 8 are already in the input, and if not add a blank column.
For that I have extracted the Field information and compared it to a list containing the field name "Column5, Column 6, Column 7, Column 8", which then create a flag (0/1) for the detour.
However it seems that my drop down tool is not sending information to my condition tool.
Would anybody have some advice on how to handle this issue, rather by correcting something on my workflow or a new approach.
Many thanks
