'Upsert the table in bigquery with the condition
I have two tables A and B with key 'place', A contains 'place' values of December month and B contains 'place' values of January month. Need to create two columns (first seen and last seen) which state If 'place' in A present in B then first seen = Dec, last seen = March, If 'place' in A not present in B then first seen = Dec, last seen = dec, for new 'place 'added in B first seen = mar and last seen =march.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|