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

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

prahlad_infy — Thu, 24 May 2018 15:52:07 GMT

Hello Sirs ,

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

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

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

Thank You

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

ehilsinger — Thu, 24 May 2018 17:58:00 GMT

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

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

ehilsinger — Tue, 29 May 2018 18:34:49 GMT

Did this help?

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

vishsaggi — Tue, 29 May 2018 19:28:06 GMT

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;

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

vishsaggi — Tue, 05 Jun 2018 12:49:18 GMT

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

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

prahlad_infy — Tue, 05 Jun 2018 13:11:46 GMT

Both Worked Actually