Transforming data and summing

LincolnMike

I have the following:

vin	date	Section	Code	Store	Hrs
1234	2017-06-01	A	XX	B224	0.01
1234	2017-06-01	B	YY	B224	1.50
1234	2017-06-02	C	ZZ	B224	0.05
5678	2017-06-03	A	XX	A112	0.01
5678	2017-06-03	B	VV	A112	1.10
9012	2017-06-04	A	XX	C666	0.01
9012	2017-06-04	B	MM	C666	0.08
9012	2017-06-30	C	ZZ	J123	0.05

Using Alteryx, how do I have the output look like this:

vin	SecA	SecB	SecC	SecA_Dt	SecB_Dt	SecC_Dt	SecA_St	SecB_St	SecC_St	TotHr
1234	XX	YY	ZZ	2017-06-01	2017-06-01	2017-06-02	B224	B224	B224	1.56
5678	XX	VV		2017-06-03	2017-06-03		A112	A112		1.11
9012	XX	MM	ZZ	2017-06-04	2017-06-04	2017-06-30	C666	C666	J123	0.14

mborriero

It's fine do not worry

I did not read that you wanted hours summed and not split.

You can modify the workflow using a Summarize tool for the Hours ColumnGlad you were able to solve your problem!