I am generating a data table from text files. I have identified my file as having tab separated fields via Notepad++.
However, when I use the Wizard to preview the conversion, the row text does not get separated into fields.
Thanks for any insights on what I am doing wrong.
it looks a little bit like tab, space and others are seperating.
Can you share some sample data?
You should use Read CSV, not Read Text File, and set it to tab as the delimiter. Then you don’t need the Generate Data Table activity, it’ll just read the file correctly, directly into a datatable.
Tab is automatically converted to space in the input text field.
You can try without wizard as follows