cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Help shape the future of Alteryx Technical Documentation by sharing your feedback!

LEARN MORE
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
SOLVED

Transforming or Transposing

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
Alteryx Partner

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

Alteryx Partner

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

Labels