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

Flip data by 90 degrees

szabolcsf
6 - Meteoroid

Hello Everyone,

I'm trying to "flip" a table by 90 degrees (see attached workflow).
I was browsing threads here, and tried using Transpose, then Cross Tab in combination with Tex to Columns (rows), but somehow it didn't get the result I need; also, using as many Text to Columns as values is often not feasible with the datasets I'm working with.

How can I get from the first to the second table as shown in the workflow?

Best,
Szabolcs

5 REPLIES 5
LordNeilLord
15 - Aurora

HI @szabolcsf

 

You were almost there, you just needed a way to group the values so they didn't end up in one row, I parsed out the number in the original header to do this:

 

Flip.PNG

szabolcsf
6 - Meteoroid

Hi @LordNeilLord,

Thanks, that looks exactly what I'm looking for!
Unfortunately I don't have the latest alteryx version and can't update yet - could you show a screenshot of the RegEx tool you've used?

 


 

LordNeilLord
15 - Aurora

@szabolcsf What version are you using? I'll downgrade it for you.

 

FlipRegex.PNG

szabolcsf
6 - Meteoroid

 Hey @LordNeilLord, that would be great, thanks!
I'm using alteryx designer 11.0.5.26351

LordNeilLord
15 - Aurora

Here we go

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Labels