How to get similar outcome?

[#1]

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.

[#2]

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

[#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..

[ashfaq_haseeb]

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

[#5]

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.