Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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.
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.
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;
It worked.
Thank you,