Dynamically delimiting and renaming the header

[adarsh2608]

Hello ,

I have requirement (attachment) i receive text file as input file to which i need to convert as excel by delimiting by coma , now the requirement is based on the text file i need to create a header and separate columns for the value as per below table. every i receive text file but data changes so the delimiting and renaming should be dynamic

Account	Value	Fixed Data	Income	Rate
ABC123001	0	0	0	0
ABC123021	0	0	0	0
ABC123051	0	0	0	0
ABC124001	0	0	0	0
ABC523001	0	0	0	0

[DataNath · Accepted solution]

Not entirely sure what you're getting at exactly. If you could provide a better example/extra info that may help.

You can read in your text file just fine and Alteryx will split it on the comma if you tell it to read the input as a csv (comma separated value), as shown below.

However, in the sample you have provided, there are no headers, hence the 'Field_1', 'Field_2' type names. I'd imagine in your live data, there will be headers, in which case you just tick the 'First Row Contains Field Names' box.

[adarsh2608]

yes , header has to removed . i worked that way . i missed it anyway thank you