Selecting distinct values of field load script

[jasmeenkr]

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

[Vegar]

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

[jasmeenkr]

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

[Vegar]

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?