Transpose mapping between two tables in Power BI

[Anonymous]

Hi All,

I have table 1 where we have age, Gender, Country ,Date and City fields. But these 4 information have been entered by different users in different manners. For eg. Alan have entered age in Field1 where asChris have entered Country in Field1 and so on.

In Table2 - we have actual field which will map with Main Field and we can identify for eg. Field1 for Alan is Age and Field1 for Chris is Country.

Provided the expected output below:

How to achieve this in power bi? or How to align age, Gender, Country ,Date and City fields?

Thanks in Advance

Regards,

Prakash M

[amitchandak]

@Anonymous , these can be steps.

1. Unpivot the first table (Main Field and value are the columns  )

2. Create a key both table main field and process. and merge two tables based on this key

3. remove Main Field if required

4. pivot Actual Field and Value

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

Hi @amitchandak ,

I have 2 rows for Alan in Table 1 thus i am getting error and if i delete one of those 2 rows and then if i execute all the steps as per your suggetion then it is working. Could you please explain me in detail on how to get the expected output for 2 rows for single process.

Thanks in Advance

Prakash