Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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;
hi
thanks it works
gidon