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.

Breaking rows into multiple columns

rajputakansha
8 - Asteroid

Hello,

 

I am trying to split my data that only contains one column into multiple columns based on their names. Here is a sample of the data-

 

Field1
order=1
Date=1/1/2023
Time=12:00
Period=Jan
Amount[NONE][NONE]100.00
[Null]
order=2
Date=2/1/2023
Time=12:00
Period=Feb
Amount[NONE][NONE]100.00
USD Amount[NONE][NONE]56.00
[Null]
order=3
Date=3/1/2023
Time=12:00
Period=Mar
Amount[NONE][NONE]100.00

 

Each segment is split with a value [NULL]. Can someone suggest the most efficient way of doing this?

 

Thankyou 

3 REPLIES 3
SPetrie
12 - Quasar

Depending on what you want done with the [NONE][NONE] values, you can use = and [ and delimiters and do a text to column split.

SPetrie_0-1685560174979.png

After that, a multi-row to establish a grouping and then a transpose to put them into columns

SPetrie_1-1685560224305.png

 

 

NMangera
10 - Fireball

@rajputakansha,

 

if you wanted to remove 'NONE' from the AMount and USD_Amount columns you could use the data cleansing tool to remove punctuation like so:

 

 

NMangera_0-1685561624746.png

 

to leave just the numeric values

NMangera_1-1685561687837.png

 

cjaneczko
13 - Pulsar

Another Take.

 

cjaneczko_0-1685561780041.png

cjaneczko_1-1685561794487.png

 

 

Labels