I have this challenge I need some help with. I need to know how to achieve my expected output from the script with the model to be a like the expected outpu. And also how to achieve it directly in the Qlik sense UI on a pivot table.
I have 2 data coming in the format below.
TableA:
Load * Inline [
home,a,b,c,
car,d,e,f,
bike,g,h,i
];
TableB:
Load * Inline [
a,123,
d,256,
g,300,
d,450,
e,830,
f,1130,
g,700,
h,1400,
i,2000
];
My Expected output is the following is (as attached):
If I understand your data correctly, this is the output. I have added headers to your data, as well as corrected some data in column1 TableB - changed 'd' to 'b' and 'g' to 'c'.
After that I loaded TableB three times separately - one time for each price variant. So that way you have the product list with price type (TableA) and 3 seperate price lists for every price type. Check the sample file.
If I understand your data correctly, this is the output. I have added headers to your data, as well as corrected some data in column1 TableB - changed 'd' to 'b' and 'g' to 'c'.
After that I loaded TableB three times separately - one time for each price variant. So that way you have the product list with price type (TableA) and 3 seperate price lists for every price type. Check the sample file.
