Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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):
Category | pricing1 | pricing2 | pricing3 | value1 | value2 | value3 |
home | a | b | c | 123 | 256 | 300 |
car | d | e | f | 450 | 830 | 1130 |
bike | g | h | i | 700 | 1400 | 2000 |
Thank you.
Eric
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.
Hi,
it will be useful if you describe the columns by adding headers.
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.
Thanks I will check and get back to you