Replace Value in Query Editor for value of another table

[K3ph4s]

Hi Community,
i would need you help.
i have a data in a "column1" of a "table A" with different values 

i would need to replace this values between "" Column1 for the value related to this code "column2" from another "Table B":

So in table A Column 1 will appear the name of "column 2" of Table B rather than de code

Anyone can help me?

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result very clearly.

[Anonymous · Accepted solution]

Hi @K3ph4s ,

Thanks Shivu-2000  for the quick reply. I would like to add another thought:

You can create a custom column in Power Query.

List.Accumulate(List.Numbers(0,Table.RowCount(#"Table B"),1),[Column1],(x,y)=>Text.Replace(x,#"Table B"[Column1]{y},#"Table B"[Column2]{y}))

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[K3ph4s]

@Anonymous  Thanks for the response; one main question: Are figures 0 and 1 the position of the columns in the tables?
i reviewing your file.... as it is simple with those two columns only, however my table contian such as 30 columns and the data is not in columns 1 or 2.

Regards

[Anonymous]

Hi @K3ph4s ,

It refers to the position of the row in which a particular column is located. It is related to the column name, not the first column.

Please refer: 

List.Numbers - PowerQuery M | Microsoft Learn

Table.RowCount - PowerQuery M | Microsoft Learn

You mentioned that you have a total of 30 columns, would you like to replace all of them? Then you can merge these columns into one column using commas and add this custom column so that you can replace them together and then split all the columns according to the commas.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Shivu-2000]

Hi @K3ph4s 

This ticket is similiar to yours, this might be helpful

https://community.fabric.microsoft.com/t5/Desktop/Power-BI-vlookup/td-p/1830713

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!

[K3ph4s]

It is similar but the huge differences is that in my case there are some values in the same cell, divided by a coma or "