Forum Discussion
Fia123
Helper II
Helper IIUNION 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 :-)
Fia123Helper II
Helper IIDo you mean, first making two new tables by use of Selectcolumns - and afterwards combined those two with use of UNION?
Fia123Helper II
Helper III 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 :-)
- vanessafvg
Community Champion
great
luxpbiHelper V
Hi,
I have the same issue, can you please explain how you solved it?
ctedesco3307Resolver II
Can you supply the syntax for this? Thnk you Fia123
