Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
[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];
Did this help?
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;
wwhat’s the issue you facing? Does any above solutions worked ?
Both Worked Actually