In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting TXT to Excel (Column Headers)

tj3678
7 - Meteor

Hi all,

 

I am trying to convert a text file to excel using the 'Text to Columns' tool, but am unable to convert/keep the column headers as the tool only separates beginning on row 2 by delimiter.  See example below:

 

Data input

 

Capture1.PNG

 

Output below

Capture2.PNG

 

Any help appreciated!

2 REPLIES 2
benakesh
12 - Quasar

@tj3678 ,

Option 1: 

Deselect  first row contains field names  and use  dynamic rename  to  change headings (take field names from first row) .

Option 2:

I see you have  \0  ( no delimiter)   for  delimiter  .  You can also use ';'  as delimiter  .

tj3678
7 - Meteor

Thanks!

Labels
Top Solution Authors