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

Parsing data from a multi-sections text file

emmanuel_varesio
7 - Meteor

Hi there,

 

I'm trying to parse a unique text file (INPUT) with different repetitive sections containing info/data that I would like to parse and re-arrange as explained below:

 

- pattern A is a regexp to parse a name from the line (orange)

- pattern B is to remove empty lines 

- pattern C is to extract the textual data and convert it to columns (tabs as delimiters) - green

- pattern D is to convert the first row of each pattern C output as unique column names in the output (blue)

 

emmanuel_varesio_0-1682956171438.png

 

The OUTPUT should contain the data as column with their field name + the first column from pattern A output

 

emmanuel_varesio_1-1682956301703.png

 

I've attached the input text file used as example.

 

Thanks in advance for your help.

 

Best regards,

 

Emmanuel

2 REPLIES 2
binuacs
20 - Arcturus

@emmanuel_varesio One way of doing this

binuacs_0-1682957219621.png

 

emmanuel_varesio
7 - Meteor

@binuacs  Thansk a lot. Seems so simple when you see the solution.

Labels