Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Partner - Creator II
Partner - Creator II

Do not know how to stop load entire row based on duplicate value in a column

Hello Sirs ,

How preventing loading of complet row row based on duplicate value in a given column ?

     

AreaPerimeterCoverageObservationObject
A1100.9OB1SqPlate
A2100.9OB1SqPlate
A2100.9OB1Rectangular Plate
A1100.9OB1Circular Disc
A2100.9OB1Circular Disc
A2100.9OB1Trapezium

I want to load only those rows which is bold . Because Object column has onle , Rectangular Plate and Trapezium as unique values


Thank You

5 Replies
ehilsinger
Contributor III
Contributor III

[Data Temp]:

LOAD * INLINE [

    Area, Perimeter, Coverage, Observation, Object

    A1, 10, 0.9, OB1, SqPlate

    A2, 10, 0.9, OB1, SqPlate

    A2, 10, 0.9, OB1, Rectangular Plate

    A1, 10, 0.9, OB1, Circular Disc

    A2, 10, 0.9, OB1, Circular Disc

    A2, 10, 0.9, OB1, Trapezium

];

[Count]:

LOAD

*

Where

([COUNT.Object Count] = 1);

LOAD

[Object] as [COUNT.Object],

Count ([Object]) as [COUNT.Object Count]

Resident

[Data Temp]

Group By

[Object];

[Data]:

NoConcatenate

LOAD

*

Resident

[Data Temp]

Where

(Exists ([COUNT.Object], [Object]));

DROP Table [Data Temp];

DROP Table [Count];

ehilsinger
Contributor III
Contributor III

Did this help?

vishsaggi
Champion III
Champion III

Try this?

DisLoad:

LOAD *, AutoNumberHash128(Area&Perimeter&Coverage&Observation&Object) AS KeyID INLINE [

Area, Perimeter, Coverage, Observation,Object

A1, 10, 0.9, OB1, SqPlate,

A2, 10, 0.9, OB1, SqPlate

A2, 10, 0.9, OB1, Rectangular Plate

A1, 10, 0.9, OB1, Circular Disc

A2, 10, 0.9, OB1, Circular Disc

A2, 10, 0.9, OB1, Trapezium

];

Right Join(DisLoad)

LOAD *

WHERE ObjCnt =1;

LOAD Object, Count(Object) AS ObjCnt

Resident DisLoad

Group By Object;

vishsaggi
Champion III
Champion III

‌wwhat’s the issue you facing? Does any above solutions worked ?

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

Both Worked Actually