Join Distinct code example
Example: Join Distinct
Original:
Load * Inline [
ID, DIM, SALES
1, A, 100
2, A, 50
3, B, 75
3, B, 75
4, C, 1000
];
tmp:
LOAD Distinct * Inline [
DIM, DESC
A, Big Fish
B, Reoccuring
B, Reoccuring
C, High Roller
];
Left Join(Original)
Load
*
Resident
tmp;
Drop Table tmp;