Transforming or Transposing

[LincolnMike]

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:

vin	rprDt	Store	LbrCd	ReprOrder	Tot_Hrs_pd_forVIN
123	2016-09-30	AX12	E	ABC	1.8
123	2016-09-30	AX12	M	ABC	1.8
123	2016-09-30	AX12	A	ABC	1.8
789	2016-11-07	GG22	A	DEF	1.9
789	2016-11-08	GG22	E	DEF	1.9
789	2016-11-09	ZZ33	N	XYZ	1.9

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

vin	RprDt1	RprDt2	RprDt3	Store1	Store2	Store3	RprOrd_LbrCd1	RprOrd_LbrCd2	RprOrd_LbrCd3	Tot_Hrs_Pd_ForVIN
123	2016-09-30	2016-09-30	2016-09-30	AX12	AX12	AX12	ABC_E	ABC_M	ABC_A	1.8
789	2016-11-07	2016-11-08	2016-11-09	GG22	GG22	ZZ33	DEF_A	DEF_E	ZYZ_M	1.9

[mborriero]

Hi @LincolnMike, please try the solution attached.

Let me know if you need any clarification.

[andre347]

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 

[LincolnMike]

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.

[LincolnMike]

Hi Andre,

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

[andre347]

Attached a version for 10.6 and the input file

[mborriero · Accepted solution]

@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]

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