Forum Discussion

Fia123's avatar
Fia123
Helper II
9 years ago
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 ...
Need Help
  • Fia123's avatar
    Fia123
    9 years ago

    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 :-)

     

Ballard-Atkins's avatar
Ballard-Atkins
Frequent Visitor
9 years ago

I found the following helpful in how JOINs work: https://stackoverflow.com/questions/38549/what-is-the-difference-between-inner-join-and-outer-join

 

I had a similar problem, I think.

 

I join two tables (TableA, TableB) that both have unique timestamps, the relationships/JOIN in PWBI didn't connect them as I wanted, so I created a new table (TableAll) with ALL the values from both TimeStamp columns, then linked TableA:TimeStamp to TableAll:TimeStamp, and TableB:TimeStamp to TableAll:TimeStamp. 

 

This way, when I use TableAll:TimeStamp as an axis, I can then reference data from both TableA and TableB.