cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Transforming or Transposing

SOLVED
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
Bolide

Hi @LincolnMike, please try the solution attached.

Let me know if you need any clarification.

Alteryx Certified Partner

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

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

 

 

Asteroid

Hi Andre,

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


Alteryx10_6Error.JPG

 

 

Alteryx Certified Partner

Attached a version for 10.6 and the input file

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.

Highlighted
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.  :)