Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a customer table like:
A sales table like:
I want to create a pivot table with dimensions: ItemCategory-rep-customer-sales, which should be like:
How should I create the model?
Join both the tables.
or use concatenate function loading merge both the tables.
Dear Wanyun,
Please pick necessary columns from second table like below:
Cust:
Load * Inline [
Customer, Rep, ItemCateogory
1,A,a
2,B,b
3,C,a
];
Sales:
Load * Inline [
Customer, Sales
1,400
2,300
];
Exit Script;
O/p,
You will get your desired output
https://community.qlik.com/servlet/JiveServlet/showImage/2-1505841-205951/333.PNG
Thanks,
Arvind Patil