Forum Discussion
Solved
Replace values based in a specific column
Hello guys, I would like your help in something. Lets say we have this table : SellerId SellerName Amount 2000 Amazon -100 2000 A ...
Duplicate the table and filter out the 'A' values so you get this
Then do a 'Merge as New' with the original table (Inner Join on ID - Seller ID).
Expand the Table column.
Tidy data as required (remove the original SellerName column)
Duplicate the table and filter out the 'A' values so you get this
Then do a 'Merge as New' with the original table (Inner Join on ID - Seller ID).
Expand the Table column.
Tidy data as required (remove the original SellerName column)