Data Transformation or Challenge

[Emma007]

Hello Everyone,

Please I kindly need your help. I  have over 2000 invoices which are in csv format. This is arranged in the format below after uploading on alteryex..

Please I  need help on how I can transform the above raw formatting to the below formatting.

[flying008 · Accepted solution]

Hi, @Emma007 

FYI.

BTW, What is your logic for the field [Invoice Date] ? the date don't like seem your input as same.

Zone	Zone Connected Calls	Zone Total Rated Duration In Minutes	Zone Total Call Charges	Price	Invoice Number	Invoice Date	Currency	Carrier Name
CELLULAR-A	1900-2-1	44	51.24	0.186	DG-090909-USD	2003-2-12	USD	DEG
CELLULAR-C	343	3,432.00	4,554.00	0.186	DG-090909-USD	2003-2-12	USD	DEG
CELLULAR-Y	12	424	343	0.185	DG-090909-USD	2003-2-12	USD	DEG
Zone	Zone Connected Calls	Zone Total Rated Duration In Minutes	Zone Total Call Charges	Price	Invoice Number	Invoice Date	Currency	Carrier Name
CELLULAR-EE	32	6,440.00	51.24	0.186	DG-090910-USD	2003-2-12	USD	DEG
CELLULAR-RT	1005	9,448.00	-4,451.52	0.186	DG-090910-USD	2003-2-12	USD	DEG
CELLULAR-WER	674	6,440.00	51.24	0.186	DG-090910-USD	2003-2-12	USD	DEG
CELLULAR-EW	343	3,432.00	4,554.00	0.186	DG-090910-USD	2003-2-12	USD	DEG
CELLULAR-O	12	424	9056.76	0.185	DG-090910-USD	2003-2-12	USD	DEG
Zone	Zone Connected Calls	Zone Total Rated Duration In Minutes	Zone Total Call Charges	Price	Invoice Number	Invoice Date	Currency	Carrier Name
CELLULAR-X	423	44.00	51.24	0.186	DG-090912-USD	2003-2-12	USD	DEG
CELLULAR-Y	424	3,432.00	52.24	0.186	DG-090912-USD	2003-2-12	USD	DEG
CELLULAR-Z	425	6,820.00	53.24	0.185	DG-090912-USD	2003-2-12	USD	DEG

[Emma007]

Hi @flying008,

This is super great. Very grateful for this submission and help. Please could you share the workflow with me?

[flying008]

Hi, @Emma007 

Due to security policy restrictions, I am unable to upload .yxmd file, so please create your own based on the workflow tool animation.

[Raj · Accepted solution]

@Emma007 one way of doing this
find the workflow attached
Mark done if solved

[grazitti_sapna · Accepted solution]

Hi,

There can be multiple ways to do this but I have tried it with join tool to get the desired output.
Try the below workflow and let me know if it worked for you or not.
Thanks

[Emma007]

Fantastic submission. Really appreciate this. Thank you