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

Transforming data based on common ID

Chirag_KRCPL
8 - Asteroid

Given below is the data (Notice that some of the Ids are repeating) :

Chirag_KRCPL_0-1663654608082.png

I want the output as follows:

IDField1Field2
110-10
220-20
33015
44020
550100
660120
75 
85 

So basically I require a new filed that will represent data based on common ID as shown in above snip.

Thanking in advance.

Regards,

Chirag

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@Chirag_KRCPL 
I was thinking to use the Tile tool but considering the case of same value for same ID, I chose to use the Multirow formula tool.

0920-Chirag_KRCPL.PNG

flying008
14 - Magnetar

Hi, @Chirag_KRCPL 

 

If you only want get split , there is have a easy way:

flying008_0-1663656669052.png

 

Input  Output  
      
IDValue IDColumn_1_ValueColumn_2_Value
110 110-10
220 220-20
330 33015
440 44020
550 550100
660 660120
1-10 75 
2-20 85 
315    
420    
5100    
6120    
75    
85    

 

录制_2022_09_20_15_09_00_829.gif

 

********

If it can help you, please mark it as a solution for share more.

Chirag_KRCPL
8 - Asteroid

@flying008 can you please share this workflow (one with tile & dynamic rename). It would be a great help!

flying008
14 - Magnetar

Hi, @Chirag_KRCPL 

 

1-2 Tile + Transpose set in below:

 

flying008_0-1663718251997.png

 

3- Dynamic Rename Expression:

 

iif(REGEX_Match([_CurrentField_], "^\d+$"),"Field" + [_CurrentField_], [_CurrentField_])

 

 

Labels