Forum Discussion
Union and then distinct values of a column
Hi, Here is a description of my problem. I have 3 tables, but i will take the example of 2. in each table, I have a column "common_col". I want to combine the values of this 2 tables to get one...
Can you try to not apply distinct before the union?
Like this:
table1
| project common_col
| union (table2 | project common_col)
| summarize by common_col //or distinct common_col