How to load distinct value?

[Foodie123]

Hello experts,

I would like to load only one row if it has the same policy number. 

I am using multiple sources and I have attached the script.

Thank you in advance!

[Oleg_Troyansky]

In a nutshell, when you load the "main" table with Policy Numbers, order it in such a way that the first record for a policy would have the best set of attributes, compared to other possible rows, and then you can add the following condition to it:

Where not exists(PolNumber)

The first row per policy will get loaded and all subsequent rows will get excluded by this condition. If you need the same condition applied to multiple tables, then you may have to play with it, depending on your specific needs.

I hope this is clear.

Cheers,

[elakkians]

Hi,

Take a Resident of the 'Autobook' table and use Load distinct.

If all the values in the Rows are the same this will work.

NoConcatenate

Autobook_Final:

Load distinct *

Resident Autobook;

Drop table Autobook;