Answers for "Join Distinct"

Whatever

0

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;

Posted by: Guest on May-25-2021

Source

Code answers related to "Join Distinct"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#