In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

NO Cartesian join required

Kuldeepmathur
8 - Asteroid

Hi,

 

I am trying to create a movement dataset where I am trying to record the movement of Ids from Last month to this month

 

My input file looks like this :

 

rpt_dt_keyIDTypeType 2DivisionPillarCost CenterCompany
5/31/202221Transfer OutExitsX Division   
5/31/202221Transfer INAddsY Division   
5/31/202221Transfer OutExits A  
5/31/202221Transfer INAdds B  
5/31/202221Transfer OutExits  C 
5/31/202221Transfer INAdds  D 
5/31/202221Transfer OutExits   E
5/31/202221Transfer INAdds   F

 

 

Expected Output is :

 

DateIDTypeType 2DivisionPillarCost CenterCompany
5/31/202221Transfer OutExitsX DivisionACE
5/31/202221Transfer INAddsY DivisionBDF

 

 

Thanks,

Kuldeep

5 REPLIES 5
grazitti_sapna
17 - Castor

Hi @Kuldeepmathur , Here is the workflow. You can achieve it by using multi join. Please let me know if it was helpful.

 

grazitti_sapna_0-1665136830034.png

 

Sapna Gupta
binuacs
21 - Polaris

@Kuldeepmathur One way of doing this with the Summarize tool

 

binuacs_0-1665137433517.png

 

Kuldeepmathur
8 - Asteroid

Thanks for the quick revert  I really appreciate your support.

 

I just added some more Ids in the data and it's actually breaking because of the date change 

 

Input : 

DateIDTypeType 2DivisionPillarCost CenterCompany
5/31/202221Transfer OutExitsX Division   
5/31/202221Transfer INAddsY Division   
5/31/202221Transfer OutExits A  
5/31/202221Transfer INAdds B  
5/31/202221Transfer OutExits  C 
5/31/202221Transfer INAdds  D 
5/31/202221Transfer OutExits   E
5/31/202221Transfer INAdds   F
6/31/202222Transfer OutExitsG Division   
6/31/202222Transfer INAddsH Division   
6/31/202222Transfer OutExits   M
6/31/202222Transfer INAdds   N

 

Output :

 

Kuldeepmathur_0-1665137907788.png

 

 

Thanks,

Kuldeep

Ben_H
11 - Bolide

Hi @Kuldeepmathur,

 

Here's an alternative method using transpose and crosstab that should work for you.

 

Ben_H_0-1665139158384.png

Ben_H_1-1665139190589.png

Regards,

 

Ben

 

 

Kuldeepmathur
8 - Asteroid

Thanks Everybody for the support !

Labels
Top Solution Authors