Data Transformation or Challenge

Question

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.

Sample.xlsx

flying008 · Accepted Answer

Hi, @Emma007

FYI.

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

ZoneZone Connected CallsZone Total Rated Duration In MinutesZone Total Call ChargesPriceInvoice NumberInvoice DateCurrencyCarrier NameCELLULAR-A1900-2-14451.240.186DG-090909-USD2003-2-12USDDEGCELLULAR-C3433,432.004,554.000.186DG-090909-USD2003-2-12USDDEGCELLULAR-Y124243430.185DG-090909-USD2003-2-12USDDEGZoneZone Connected CallsZone Total Rated Duration In MinutesZone Total Call ChargesPriceInvoice NumberInvoice DateCurrencyCarrier NameCELLULAR-EE326,440.0051.240.186DG-090910-USD2003-2-12USDDEGCELLULAR-RT10059,448.00-4,451.520.186DG-090910-USD2003-2-12USDDEGCELLULAR-WER6746,440.0051.240.186DG-090910-USD2003-2-12USDDEGCELLULAR-EW3433,432.004,554.000.186DG-090910-USD2003-2-12USDDEGCELLULAR-O124249056.760.185DG-090910-USD2003-2-12USDDEGZoneZone Connected CallsZone Total Rated Duration In MinutesZone Total Call ChargesPriceInvoice NumberInvoice DateCurrencyCarrier NameCELLULAR-X42344.0051.240.186DG-090912-USD2003-2-12USDDEGCELLULAR-Y4243,432.0052.240.186DG-090912-USD2003-2-12USDDEGCELLULAR-Z4256,820.0053.240.185DG-090912-USD2003-2-12USDDEG

Raj · Accepted Answer

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

grazitti_sapna · Accepted Answer

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