Load one value

[gidon500]

hi guys

I have a data that I need to load one value OF A  , no matter which line

A   B   C

1   3   5

2   6   7

1   5   9

2   9  5

I need the result to be

A  B  C

1  3  5

2  6  7

thanks

gidon

[Kushal_Chawda · Accepted solution]

Data:

LOAD *,RecNo() as Rec Inline [

A ,  B,   C

1,   3,   5

2,   6,   7

1,   5 ,  9

2,   9 , 5 ];

Inner Join

LOAD A,

min(Rec) as Rec

Resident Data

Group by A;

[petter]

Data:

LOAD

     A,

     FirstValue(B) AS B,

     FirstValue(C) AS C,

     RecNo() AS Rec

INLINE [

A, B, C

1 , 3, 5

2 , 6, 7

1 , 5 , 9

2,  9 , 5

]

GROUP BY

    A;

[gidon500]

hi

thanks it works

gidon