Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have a problem of data management, and I hope to have put a clear title.
I have this kind of data: some seller, some products, and the quantity of product sold in two months.
seller product jan feb
a aa 1 2
a ab 2 3
b ba 3 1
b bb 3 8
here in a way Qlik-edible waty;
load*inline
[ seller, product, jan, feb
a,aa,1,2
a,ab,2,3
b,ba,3,1,
b,bb,3,8
];
I'd like to have the data in this way, using the load script:
seller product month quantity
a aa jan 1
a aa feb 2
a ab jan 2
a ab feb 3
b ba jan 3
b bb feb 1
b ba jan 3
b bb feb 8
how can I reach this?
Thanks for your time
transform it as follow
Crosstable (Month, Quantity, 2) load * inline
[ seller, product, jan, feb
a,aa,1,2
a,ab,2,3
b,ba,3,1,
b,bb,3,8
];
transform it as follow
Crosstable (Month, Quantity, 2) load * inline
[ seller, product, jan, feb
a,aa,1,2
a,ab,2,3
b,ba,3,1,
b,bb,3,8
];
result :
Use Cross Table
Crosstable (Month, Sales, 2) load*inline
[ seller, product, jan, feb
a,aa,1,2
a,ab,2,3
b,ba,3,1,
b,bb,3,8
];