Alteryx designer Discussions

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

Text to Columns Single Row

Highlighted
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

 

 

Highlighted
15 - Aurora

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

 

different delimeters.png

Highlighted
15 - Aurora

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

 

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

Highlighted
8 - Asteroid

thank you, that worked great!

Labels