Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QliXperts,
I need to convert the below single line of data into three.
This is my actual data.
Receiving Date | Doc In | Avarage package | Batch Type | BatchID | Barcode | ComplaintID | Assign Date | Date Scan | System | ||
6/29/2016 15:32 | 3 | 30 | Outer Package | 681633 | 16005003228 to 16005003230 | 6/29/2016 15:32 | 6/29/2016 15:34 | Vat Tool
|
I need to covert that into three based on Barcode column Like below
Receiving Date | Doc In | Avarage package | Batch Type | BatchID | Barcode | ComplaintID | Assign Date | Date Scan | System |
6/29/2016 15:32 | 3 | 30 | Outer Package | 681633 | 16005003228 | ######### | ######### | Vat Tool | |
6/29/2016 15:32 | 3 | 30 | Outer Package | 681633 | 16005003229 | ######### | ######### | Vat Tool | |
6/29/2016 15:32 | 3 | 30 | Outer Package | 681633 | 16005003230 | ######### | ######### | Vat Tool |
Any help would be appreciated.
Thanks,
Villa
Try like:
Load *,
SubField(Barcode,'to',1)-1+IterNo() as Barcode2
While SubField(Barcode,'to',1)-1+IterNo() <=SubField(Barcode,'to',2);
Load * Inline [
"Receiving Date", "Doc In", "Avarage package", "Batch Type", BatchID, Barcode
6/29/2016 15:32, 3, 30, Outer Package, 681633, 16005003228 to 16005003230
]