Making one row into severals

[martinqlik]

Hello Qlikers,

Actually, I have a table that comes all data into one single line, like below:

FISCAL DOCUMENT  ITEM 1                    ITEM 1 QTY    ITEM 2                  ITEM TWO QTY     ITEM 3                 ITEM 3 QTY 

999999328                  83.402.00152-8b             3              85.110.00140-1b              1                  85.110.00141-8b            5

I would like to show data in this model:

FISCAL DOCUMENT        ITEMS                       QTY

999999328                        83.402.00152-8b          3

                                          85.110.00140-1b          1

                                          85.110.00141-8b          5

It must be done in the script. I have tried Crosstable prefix, but it doesn't working properly.

Does anyone knows how to get it?

[sunny_talwar]

Can you share what you have tried thus far? It sometimes helps to see what you have done to explain what you might be doing wrong.

[martinqlik]

Hello,

I didn't get properly the right way for doing that development. I have an ideia that can be done by using Crosstable prefix, but I have never developed in such a way.

Thank you.

[vishsaggi · Accepted solution]

May be one way could be like

CrossTable(ITEMSLIST, QTY)

CrossTab:

LOAD FISCALDOCUMENT,

    ITEM1&'|'&ITEM1QTY,

    ITEM2&'|'&ITEM2QTY,

    ITEM3&'|'&ITEM3QTY

      INLINE [

FISCALDOCUMENT,  ITEM1,  ITEM1QTY, ITEM2, ITEM2QTY, ITEM3, ITEM3QTY

999999328,  83.402.00152-8b, 3,85.110.00140-1b,1,85.110.00141-8b,5

];

NoConcatenate

Final:

LOAD FISCALDOCUMENT,

    Subfield(QTY, '|',1) AS ITEMS,

    Subfield(QTY, '|',2) AS QTY              

Resident CrossTab;

DROP TABLE CrossTab;

[martinqlik]

It worked.

Thank you,