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

Dynamically Turning Multiple Columns into one Column

dlesny
8 - Asteroid

Hi

How to append data from multiple columns into one dynamically?

I have the following excel: Dynamically dependent on how many tasks under story the number of Columns increases _0_, _1_, _2_... but its always the same amount of columns for each task like here 3.

 

Story_FormattedIDStory_PortfolioItemTask_0_FormattedIDTask_0_IterationTask_0_OwnerTask_1_FormattedIDTask_1_IterationTask_1_Owner
US1Form TeamsTA1ITR1JohnTA2ITR1Alex
US2BacklogTA4ITR5PaulTA2ITR4Steve

 

How can I change it to this please:

 

Story_FormattedIDStory_PortfolioItemTask FormattedIDTask IterationTask Owner
US1Form TeamsTA1ITR1John
US1Form TeamsTA2ITR1Alex
US2BacklogTA3ITR5Paul
US2BacklogTA4ITR5Steve

 

3 REPLIES 3
jamielaird
14 - Magnetar

Hi @dlesny 

 

The attached workflow should give the result you are looking for. Let me know if you have any questions at all.

 

Screenshot 2019-05-07 at 16.25.04.png

-----
If I've solved your problem please consider marking this solution as accepted. Thank you!

afv2688
16 - Nebula
16 - Nebula

Hi @dlesny ,

 

Here you go

 

Cheers

dlesny
8 - Asteroid

Awesome, Thank you

Labels