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 or Transposing

LincolnMike
8 - Asteroid

Hi,

I have a this data set that does not associate as well with previous solutions this great community previously solved for me.  I can't seem to combine the Cross Tabs needed to resolve.

 

I have this for my data:

vinrprDtStoreLbrCdReprOrderTot_Hrs_pd_forVIN

123

2016-09-30AX12EABC1.8
1232016-09-30AX12MABC1.8
1232016-09-30AX12AABC1.8
7892016-11-07GG22ADEF1.9
7892016-11-08GG22EDEF1.9
7892016-11-09ZZ33NXYZ1.9

 

This is the desired output, with Concatenating Repair Order to Labor Cd:

vinRprDt1RprDt2RprDt3Store1Store2Store3RprOrd_LbrCd1RprOrd_LbrCd2RprOrd_LbrCd3Tot_Hrs_Pd_ForVIN
1232016-09-302016-09-302016-09-30AX12AX12AX12ABC_EABC_MABC_A1.8
7892016-11-072016-11-082016-11-09GG22GG22ZZ33DEF_ADEF_EZYZ_M1.9
7 REPLIES 7
mborriero
11 - Bolide

Hi @LincolnMike, please try the solution attached.

Let me know if you need any clarification.

andre347
10 - Fireball

I've attached packaged workflow with a solution. I used the Crosstab tool and the multi join to bring all the cross tabs together.

 

Let me know if you need more help 

 

Screen Shot 2017-08-04 at 14.07.32.png

LincolnMike
8 - Asteroid

Hello mborriero,

I have Alteryx Designer version 10.6, and I get the error message that it will not open due to more recent version used.

 

Alteryx10_6Error.JPG

 

 

LincolnMike
8 - Asteroid

Hi Andre,

i get the following when I try to open the yxmd:


Alteryx10_6Error.JPG

 

 

andre347
10 - Fireball

Attached a version for 10.6 and the input file

mborriero
11 - Bolide

@LincolnMike, try this please and let me know if you can open it.

@andre347 I like the way how you can achieve the same results in different way. However you forgot to concatenate reporder and LbrCD. I have decided to implement a dynamic solution, in this case If new fields will be added to the database, you will not need to review your workflow.

LincolnMike
8 - Asteroid

Thank you @mborriero and @andre347,

I have been plugging in the solution offered to our Database (about a million rows), and applying a few adjustments and I am getting closer to the results I need.  Mborriero, thanks for applying the dynamic solution, because it helped me find some Stores that submitted 3 repair orders.  I may need further support.  :) 

Labels