Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
uroboros
Creator
Creator

Why make distinct in the first table?

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!

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

i think its a know behaviour as reported by @barryharmsen 

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

 

Gabriel
Partner - Specialist III
Partner - Specialist III

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
MVP
MVP

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() .