Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , I got a requirement that i have shuffle column as row. below is the requirement
Stock | item | Itemtype | Sale | InStock |
---|---|---|---|---|
Store1 | I1 | Product1 | 1 | 1 |
Store1 | I2 | Product2 | 0 | 1 |
Store2 | I1 | Product1 | 0 | 0 |
Store2 | I3 | Product2 | 3 | 4 |
AS
Item | Item Type | Stock | Store1 | Store2 | |
---|---|---|---|---|---|
I1 |
| Sale | 1 | 0 | |
Product2 | InStock | 1 | 0 | ||
I2 |
| Sale | 0 | 3 | |
Product2 | InStock | 1 | 4 |
I will look forward to appreciate your answer
Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you
Can you not simply deploy as a pivot table in the front end?
Please try this
tab1:
CrossTable(salesinstack, value, 3)
LOAD Stock,
Item,
itemtype,
Sale,
instock
FROM
(ooxml, embedded labels, table is Sheet1);
Tab2:
generic Load Item,
Stock,value Resident tab1;
or you can use crosstable
beck
Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you
pivot table :dimentions are item,itemtype,salesinstack,store1,store2
Expression:Sum(item)
Item | itemtype | salesinstack | store1 | store2 | Sum(Item) |
---|---|---|---|---|---|
11 | product1 | instock | 1 | 0 | 22 |
Sale | 1 | 0 | 22 | ||
12 | product2 | instock | 0 | - | 12 |
1 | - | 12 | |||
Sale | 0 | - | 12 | ||
1 | - | 12 | |||
13 | product2 | instock | - | 3 | 13 |
4 | 13 | ||||
Sale | - | 3 | 13 | ||
4 | 13 |
itemtype | store1 | store2 | Item | salesinstack |
---|---|---|---|---|
product1 | 1 | 0 | 11 | instock |
product1 | 1 | 0 | 11 | Sale |
product2 | 0 | 12 | instock | |
product2 | 0 | 12 | Sale | |
product2 | 1 | 12 | instock | |
product2 | 1 | 12 | Sale | |
product2 | 3 | 13 | instock | |
product2 | 3 | 13 | Sale | |
product2 | 4 | 13 | instock | |
product2 | 4 | 13 | Sale |
Please try this
under transformation wizard select crosstable ,set qualifier field is 3,Attribute field is salesinstack and Data field is Value.
tab1:
CrossTable(salesinstack, value, 3)
LOAD Stock,
Item,
itemtype,
Sale,
instock
FROM
(ooxml, embedded labels, table is Sheet1);
Tab2:
generic Load Item,
Stock,value Resident tab1;