Forum Discussion
Mapping columns
Hi,
I have data in a sheet with column names
Date
Facebook Fans
Twitter Messages
Tweets
FB Posts
Twitter followers
FB followers
now I want to create a new table with columns
SM platform with data - Facebook and Twitter
No. SM Platform
1 Facebook
2 Twitter
so I can create a relationship in between these two tables and create a slicer of SM platform for use in reports
Try to change your main table with unpivot table function in power query.
U get this:
After this u can create relationship between your tables by Attribute column.
2 Replies
First problem is they don't have a common structure (e.g. FB doesn't have Tweets.) That said, you could do the following:
1. Create 2 copies of the table in Power Query
2.a For the FB table, set all of the Twitter columns to null and add a calculated column (platform) ="Facebook".
2.b For the Twitter table, set all of the FB columns to null and add a calculated column (platform) ="Twitter".
Note: A Twitter and FB column may mean the same thing on the 2 different platforms (e.g. FB followers and Twitter followers). In that case, instead of setting the other to zero, you could rename the associated column to "Followers" and delete the other one.
3. Append the tables as a new (combined) table.
Cheers!
Nathan
Try to change your main table with unpivot table function in power query.
U get this:
After this u can create relationship between your tables by Attribute column.
