Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I load this table:
Name | Location | City |
A | AJ | ASD |
B | BH | ERF |
C | CF | HUY |
A | TY | HFM |
D | GD | HUJ |
E | YT | OPL |
F | RY | KJI |
G | PH | MLF |
I | JK | DNG |
A | TY | HFM |
B | UI | DGT |
To get this:
Name | Location | City |
A | AJ | ASD |
B | BH | ERF |
C | CF | HUY |
D | GD | HUJ |
E | YT | OPL |
F | RY | KJI |
G | PH | MLF |
I | JK | DNG |
I do not want the name field to have duplicates.
Thank you.
T:
LOAD Name,
Location,
City
FROM xyz;
NoConcatenate
LOAD Name,
FirstValue(Location) as Location,
FirstValue(City) as City
Resident T
Group By Name;
DROP Table T;
T:
LOAD Name,
Location,
City
FROM xyz;
NoConcatenate
LOAD Name,
FirstValue(Location) as Location,
FirstValue(City) as City
Resident T
Group By Name;
DROP Table T;
@Pierre11 if it is always first value then easiest way would be below instead applying complex grouping
Data:
LOAD
Name,
Location,
City
FROM Source
where not Exists(Name);