Forum Discussion
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 |
Need to replace rows 1 for Order and 1 and 3 of Seria
I choose to use the Table.ReplaceMatchingRows function but unfortunately function doesn't return the required output neither throws error. Statement I am using
Table.ReplaceMatchingRows(#"Renamed Columns",{{[Order = 1],[Order = 0]}})
Above statement didn't throw any error neither it replace values to 0, above statement is a example one as I get the columns to be replace dynamically through parameters.
Thanks
Siva
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]}})
2 Replies
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.
