Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
hope you can help. I have this script:
T1:
LOAD * Inline [
F1, F2
a, 1
a, 2
b, 3
c, 4
];
T2:
LOAD DISTINCT * Inline [
F1, F2
a, 1
b, 3
b, 3
c, 4
];
I need to have this result:
F1 F2
a 1
a 2
b 3
c 4
a 1
c 4
b 3
It should only have one table in the data model with the content as shown above. Data should not be change in the two sources only the Load script.
hope someone can help. thanks.
i run your script but the last three rows are wrong, yours is a b c, it should be a 1, c 4, b 3
Hi Tresesco I ran your script and it worked. Why ans what is the purpose of Dummy...
What wonders me is the changing of position of c 4 and b 3.. its a challenge I think..
Hi,
This is how QlikView works, It compresses data and shows only distinct values in front end.
If you want to see the backed logic, Clict CTL+T to go to table viewer and select the table right click and click preview.
As shown in the attached diagram.
Hope it helped.
Regards
ASHFAQ
Thanks for the quick explanation. Where in the script that allows the interchange of position of b 3 and c 4 from T2...
In normal progression its suppose to be in order or apperance but in here c4 comes first than b3.. where in the script that allows the transpose if you may. thanks again.