Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Text to Columns Single Row

alphabex18
8 - Asteroid

Hi all, am cleaning up a .txt file (attached sample). I input the data as a Delimited file with no deliminators, and started he data import on line 5. 

 

here are my blocks.

 

The first row of data is unique, because it has the column headers separated by commas, but the subsequent data is deliminated by tabs. Ultimately, i want the first row of data to be my field names, but i cant seem to get there with using mulitple text to column tools, and the dynamic rename

 

is there a way to split just one row by commas, and the rest by tabs?

 

In addition, at the bottom of this report are Totals and Subtotals that i would also mike to remove

 

Thank you

 

 

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

You can specify both delimeters in the same text to columns tool

 

different delimeters.png

DavidP
17 - Castor
17 - Castor

To remove the last two rows you can use a filter tool on [Group Name] with formula

 

!Contains([Group Name], @'Grand Total')

alphabex18
8 - Asteroid

thank you, that worked great!

Labels