Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
brunopaulo
Partner
Partner

Load Distinct

Hi community,

I want Load 4 fields from a resident table. In this table i have ID_Employee, Name Employee, Function, UnityBussiness.

I want load this where ID_Employee must be distinct. Any ideas?

Thanks in advance
Best Regards

Bruno Paulo

14 Replies
vishsaggi
Champion III
Champion III

May be another way ?

Tab:

LOAD *, IF(ID = Previous(ID), 0, 1) AS RowNum INLINE [

ID,          Name,               Function,          Unity

1,               Bruno,               cooker,          kitchen

1,               Bruno,               cooker,          kitchen

2,               Andrew,         engineer,       company

2,           andrew,               engineer,          company

];

NoConcatenate

Final:

LOAD *

Resident Tab

Where RowNum = 1;

Drop Table Tab;

amartinez35
Partner
Partner

Hi,

Source_Temp:

Load * Inline [

ID, Name, Function,Unity

1, Bruno,cooker,kitchen

1, Bruno,cooker,kitchen

2, Andrew,engineer,company

2, andrew,engineer,company

];

NoConcatenate

LOAD

  *,

  ID as ID2

Resident Source_Temp

Where not Exists(ID2, ID)

;

DROP Table Source_Temp;

brunopaulo
Partner
Partner
Author

Sorry, is hard for me create examples, but i solved the problem. Thank you

brunopaulo
Partner
Partner
Author

Yes dat was my error Andrew should be equal. But i solved the problem Thank you

balar025
Creator III
Creator III

I think this should work

Source_Temp:

Load *

where not exists(ID);

Load * Inline [

ID, Name, Function,Unity

1, Bruno,cooker,kitchen

1, Bruno,cooker,kitchen

2, Andrew,engineer,company

2, andrew,engineer,company

];