Model creation

[wanyunyang]

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?

[rangam_s]

Join both the tables.

or use concatenate function loading merge both the tables.

[arvind_patil]

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