Forum Discussion
Solved
Adding rows based on a unique value
Hi I am fairly new to M Query and need some help with the following: I have two Queries. Query1 and Query 2. Both have unique values. I need the column in Query 2 to be added to Query 1 for each ro...
Hi,
To perform the cross join, firstly, you will need to add a custom column in both the table and give a value as = 1
Then do a left join from query 1 to query 2 on Custom column. Lastly, you will need to expand the column.
If you need any other help, let me know.
Hi,
To perform the cross join, firstly, you will need to add a custom column in both the table and give a value as = 1
Then do a left join from query 1 to query 2 on Custom column. Lastly, you will need to expand the column.
If you need any other help, let me know.
This worked perfectly! Thank you so much!
