Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
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];

Highlighted
Contributor III
Contributor III

Did this help?

Highlighted
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;

Highlighted
Champion III
Champion III

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

Highlighted
Creator
Creator

Both Worked Actually