Forum Discussion
Merging Snowflake column and SQL column
hello kiru18
how about merging those two table in power query after you import those two table (i assumed your report visual is in PBI).
from the screenshot, it should be possible using merge query since merge query can have multiple column to merge.
- table 1
- table 2
- result
as you can see, the row 1 has merged value, however in row 2 it has null because it did not find any same value in both column1 and column2 from table 1 and table 2.
Hope this will help.
Thank you.
Super Userhello kiru18
how about merging those two table in power query after you import those two table (i assumed your report visual is in PBI).
from the screenshot, it should be possible using merge query since merge query can have multiple column to merge.
- table 1
- table 2
- result
as you can see, the row 1 has merged value, however in row 2 it has null because it did not find any same value in both column1 and column2 from table 1 and table 2.
Hope this will help.
Thank you.
Hi Irwan,
Thanks for your response. I too tried with Power Qry. But it shows NULL value from Table2.
NOTE: I expect the result like below (the row 'a' has two values. but it has to pick value from table1)
Column1 Column3 a 10 b 20 c 12 Thanks
- Irwan
hello kiru18
null probably because there is no match when merging query.
seems plausible but please share your sample data of sql table and snowflake imported into PQ.
the sample data in your screenshot seems have already been merged (not original data of sql or snowflake)
dont use my example data above, as it is just an example to show merge query.
Thank you.
