Replace Values from Different tables

Question

Hey Guys,&nbsp;I need help with this query in M-code.I have one table which has general data and is quite big and slow (Table1). I also have another table which has newer data, fast and shiny (Table2). I need a new table "Table3" which has all values and colums of Table1, but everytime Table2 and Table1 have the same column name, I need the "newer" value from Table 2.Also, I need all columns from both Table1 and Table2&nbsp;It should look like this:&nbsp;&nbsp;Is there a fast way to do thisThanks for your help, really appreciate it. 3 tables below.&nbsp;Greetings,JanikTable1IdentNoValue1Value2Value3Value21Value301196892045151510062591827541957166293784210061295714503846629662984573940957195714068675855723523752384633412512576887689238602395699565785423235&nbsp;Table 2IdentNoValue1Value3Value21Value_New1273912335123421006844343358423215121526409571231252422Table3(Goal)IdentNoValue1Value2Value3Value21Value30Value_New1119689204515151006&nbsp;273982123356629123378421006129571&nbsp;42841006848443433584402321512401526405895712312523524227523846334125125768&nbsp;876892386023956&nbsp;99565785423235&nbsp;

nickolajjessen · Answer

Fun challangeGood job for including table format data in your post!!&nbsp;https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg

anonymous · Answer

Thanks for your answers.I need a solution directly in M with a query in the end as I do this in Power BI Dataflows and need a data table like Table3.Any suggestions in M?Thanks! 🙂

nickolajjessen · Answer

Just pivot table2 it back to original format 🙂

Add this to the last step on table 2:

= Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[Attribute]), "Attribute", "Value")

Forum Discussion

Replace Values from Different tables

3 Replies

Related content

Replacing values with Iterations

Replace Errors values with Null values

Replace values

Date Different return wrong value

Replace multiple values at once (replace value)

IdentNo	Value1	Value2	Value3	Value21	Value30
1	196	89	2045	1515	1006
2	591	82	7541	9571	6629
3	784	2	1006	12	9571
4	503	84	6629	6629	84
5	739	40	9571	9571	40
6	867	58	557	23	523
7	523	84	6334	125125	768
8	768	92	3860	23	956
9	956	5	7854	2323	5

IdentNo	Value1	Value3	Value21	Value_New1
2	739	123	35	123
4	2	1006	84	43433
5	84	232	1512	152
6	40	9571	2312	52422