Forum Discussion
New column with values from another table
Hello.
I have a table (Table A) with different columns which has a date column and I need another column (LT) with values from another table (Table B).
Table A:
| Date | Week |
| 06/02/2023 | 202306 |
| 13/03/2023 | 202311 |
Table B:
| A | DESC |
| 001 | a |
| 002 | b |
| 003 | c |
Final table A:
| Date | Week | LT |
| 06/02/2023 | 202306 | 001 |
| 06/02/2023 | 202306 | 002 |
| 06/02/2023 | 202306 | 003 |
| 13/03/2023 | 202311 | 001 |
| 13/03/2023 | 202311 | 002 |
| 13/03/2023 | 202311 | 003 |
Thank you.
2 Replies
Syndicate_Admin , use generate or crossjoin
generate(Table1, Table2)
Thank you but I do not want another table. I want to add a new column to table A with values from column LT from table B. Is it possible?
