I have a semi-unstructured data file. The unstructured part is a header section which is somewhat "free-style".
At the moment I am using the input data tool 3 times to pull 1) 2 items from a header section and 2) pull delimited data from from the structured part of the file. So, i all cases, I am pulling data from (each) a file with 3 input data tools.
For 1) I am using the "start row", "row numbers to read" and special delimiters to read the rows from the unstructured data that I am interested in.
As such, the 3 data input tools have a special configuration each, although they are linked to the same file.
The problem arises when I want to loop over a number of files. How can I keep the input file names in sync across the 3 input tools?
Is there a better way to do this altogether?
Thanks very much in advance.
Solved! Go to Solution.
Thanks @atcodedog05! Would this be more efficient? I didnt think of leveraging the file name, but, its a good idea, also to have some kind of traceability of the data.
Happy to help : ) @franc1s
Cheers and have a nice day!
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |