Input file is embedded in a .yxdb that has extra data in the file prior to the comma delimited data. I removed the extra data so the file now has the column names in the first row. However, it doesn't seem to recognize the delimiter as all the data remains in one field. I tried text to column and dynamic rename of columns with first row, yet the data is still remains in the first field as one string.
Solved! Go to Solution.
can you attach a sample? usually you are parsing the wrong column - wrong delimiter or dynamic rename isnt configured correctly.
@jams1614 One way of doing this