Forum Discussion
Solved
UNION function mixes columns
Hi, I know that this subject has been discussed earlier in this forum, but I still don't know how to solve my issue. I am making a PWBI model based on data from two different ERP systems. I have ...
I used Selectcolumns first and then the UNION function - and it worked great!!!!!!
This is a much more tidy way to do it - it provides a clear distinction between extrated and transformed data.
Thank you very much - a learn something new :-)
Do you mean, first making two new tables by use of Selectcolumns - and afterwards combined those two with use of UNION?
I used Selectcolumns first and then the UNION function - and it worked great!!!!!!
This is a much more tidy way to do it - it provides a clear distinction between extrated and transformed data.
Thank you very much - a learn something new :-)
great
Hi,
I have the same issue, can you please explain how you solved it?
Can you supply the syntax for this? Thnk you Fia123
