Why make distinct in the first table?

[uroboros]

Hi everyone,

I have one issue with a Script. When I load data with the next structure:

Tbl:
Load Field,Field1,Field2,Key resident OriginX;

Left Join(Tbl)
Load Distinct Field3,Field4,Key resident OriginY;

It makes distinct into all table not only the table that  I'm loading in the second part.

Before the last upgrade this issue don't happened; It's a Issue or I'm doing something wrong.

Regards!

[dplr-rn · Accepted solution]

i think its a know behaviour as reported by @barryharmsen 

http://www.qlikfix.com/2013/07/30/distinct-can-be-deceiving/

[Gabriel]

Hi,

If you wanted just one table to be distinct you can load that table separately then you left join as you wanted to do before

[Vegar]

You could try out @Gabriel  approach, it will work. Just make sure you don't get multiple rows with the same key value in the distinct table. 

You could also try creating two mapping tables and add the data using Applymap() .