Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
I am trying to load distinct values of field.
I am using distinct key word but it is still carrying duplicates
What I am doing wrong
LOAD Distinct will only give you one row of each identical complete row of your table. The LOAD SCRIPT below will reduce the source by one row containing A, B, C. The final count of rows will be 3.
LOAD distinct * inline [
FieldA, FieldB, FieldC
A, B, C
AA, B, C
AA, BB, C
A, B, C
];
Hi All,
Table:
Load 2,3, from qvd 1--count 21
load 4,5 from qvd2--count 313
load 6,7 from qvd 3--53K
Table1:
Load 2,3 ,if(4='True',5) as count
resident table;
The count gets multifold
I'm sorry, but I dont really understand your description. Could you try do describe it using a coulpe of tables and explain your desired output?