Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Split multiple columns in to two

umarabdulsattar3275
7 - Meteor
 

I want to split multiple column in to row, according number of evseId

if evseId have two ID I want to split all other column two times. some cell have 10 evseId I want to spilt (ChargingNetwork, Country, PowerTyer, Price and PriceType) 10 times.

umarabdulsattar3275_0-1675953038464.png

 

2 REPLIES 2
SPetrie
13 - Pulsar

I think I understand the ask and believe this may work for you.

SPetrie_0-1675981399807.png

SPetrie_2-1675981479894.png

 

binuacs
20 - Arcturus

@umarabdulsattar3275 attaching the workflow. please verify the output

 

binuacs_0-1675981710973.png

 

Labels