I ran into another snag. To keep my csv file simple I divided them up into several files. I placed the corresponding sub csv file name along with the full path in the master csv file. This is very similar how a relational database is set up. So inside a tableloop I am wanting to read the current row csv file. Read File / Path I selected Use Variable. This is not working. Apparently File Read cannot read a file path from a variable.
So my next idea was to make a list within a list within a list. I placed each sub csv file contents into a variable in my master csv file. To do this I am using a pipe stem and backward slash as delimiters. With this method I am using Variable Operate to divide the variable into a new table variable using Processing Way / delimiters and adding my delimiter in the Split String field. This idea has not worked either.
Any ideas on how the best way to do this?