Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
techvarun
Valued Contributor II

Split single line data into Many

Hi QliXperts,

I need to convert the below single line of data into three.

          This is my actual data.

Receiving DateDoc InAvarage packageBatch TypeBatchIDBarcodeComplaintIDAssign DateDate ScanSystem
6/29/2016 15:32330Outer Package68163316005003228 to 16005003230 6/29/2016 15:326/29/2016 15:34Vat Tool
Header 1

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

    

Receiving DateDoc InAvarage packageBatch TypeBatchIDBarcodeComplaintIDAssign DateDate ScanSystem
6/29/2016 15:32330Outer Package68163316005003228 ##################Vat Tool
6/29/2016 15:32330Outer Package68163316005003229 ##################Vat Tool
6/29/2016 15:32330Outer Package68163316005003230 ##################Vat Tool

Any help would be appreciated.

Thanks,

Villa

1 Reply
MVP
MVP

Re: Split single line data into Many

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

]