Forum Discussion
Solved
Table.ReplaceMatchingRows not working as expected
I have a requirement to replace multiple values of a multiple columns in a table, like Order Item Qty Serial 1 2 3 1 1 1 1 1 3 1 3 1 1 1 3 ...
siva_powerbi that is because you did not provide the record for the whole row to be replaced
Table.ReplaceMatchingRows( #"Changed Type",{{[order = 1,item=1,quantity=1,serial=1],[order = 0,item=1,quantity=1,serial=1]}})
siva_powerbi that is because you did not provide the record for the whole row to be replaced
Table.ReplaceMatchingRows( #"Changed Type",{{[order = 1,item=1,quantity=1,serial=1],[order = 0,item=1,quantity=1,serial=1]}})
Thanks for the solution its working but my requirement is dynamic is their any way that we can replace all values in column with out matching and not using the table.replacevalues.