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