Rename the columns of a table using the values from another table.

[Dilesha08]

I am trying to rename the columns of a table using the values from another table.

GetIssues

Column1.fields.customfield_10041	Column1.fields.customfield_10042	Column1.fields.customfield_10043
xxx	xxx	xxx
xxx	xxx	xxx

field

Id	Name
Column1.fields.customfield_10041	a
Column1.fields.customfield_10042	b
Column1.fields.customfield_10043	c

I want to rename the first table as the below table.

a	b	c
xxx	xxx	xxx
xxx	xxx	xxx

Note

1. I am doing a Jira analysis 

2. Not all the columns are in the format of Column1.fields.customfield_10041

Can you please help me to do this?
Thanks.
@v-chuncz-msft 

@MarcelBeug 

[Mariusz]

Hi @Dilesha08 

Please see the attached file with a solution 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[marjolijn]

Thanks, that helped me a lot!

[Dilesha08]

@Mariusz I get the following error when I apply changes.

Actually I want to match the exact column name from table 2 and add it to table 1. Also, the specific columns are not in order. Only we can match them with their id.

[Mariusz]

Hi @Dilesha08 

Sorry, but I have no idea what that error is without investigating.

Have you applied the steps as in the file? does it work in PQ?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Dilesha08]

@Mariusz Yes, I have followed up on your steps. But the issue is I want to take the data from another table, not from a list. I don't have an idea to do it. 

[Greg_Deckler]

Are you looking for a Power Query or DAX solution?