Store a text file (tab-delimited) into a data table

Help Studio
,
1

Hello,

I want to ultimately import a downloaded text file into a data table.

Currently, when using the “Generate Data Table” activity with the following options:

  • Format set to Custom
  • Column separator set to Tab
  • Pressing Preview shows an error indicating that the header in the first column already exists in this table.

Since the first column is not needed, I checked the “Ignore First Column” option and pressed Preview again. The preview is displayed, but the column headers and the content from the second row onward are misaligned.

What measures can be taken to resolve this? It’s not necessary to use the “Generate Data Table” activity. However, some values in the text file have leading zeros, so they need to be treated as strings. I would prefer to create this using Modern activities, but if that’s difficult, using Classic activities is fine.

Please lend me your expertise.

2

Duplicated post

3

@Shoooon

may be sending a sample would help

but you can also consider using read csv with tab separator

also if first line is creating issue or misformated then try using regex and start from second row

cheers