Mapping columns

[adityavighne]

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

[petrovnikitamai · Accepted solution]

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.

[Anonymous]

@adityavighne  - 

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