Split single line data into Many

techvarun — Wed, 25 Nov 2020 16:16:04 GMT

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

Outer Package

681633

16005003228 to 16005003230

6/29/2016 15:32

6/29/2016 15:34

Vat Tool

Header 1

I need to covert that into three based on Barcode column Like below

Any help would be appreciated.

Thanks,

Villa

Re: Split single line data into Many

tresB — Wed, 13 Jul 2016 06:57:55 GMT

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

]