That is brilliant, and I'm still working on understanding how it all fits together, but I did have a go myself, this did mean having a unique date or index column, then Table.SelectRows(
Hi Sensai, could you please let me know whether this is possible in pq I have two tables in powerquery One table -Custreview ProductId, customer-comments 100, it sucks 102, this is amazing Second table -custmoderate ProductId, lookupword, replaceword 100, sucks, not good 100,it, this 102,amazing,exemplary From Custreview table match Product Id with custmoderate table; if matched; take customer comments field from Custreview and replace lookupword with replaceword. One Product Id can have 100's of word that need to be replaced. Please guide me how to do it in powerquery.
I think the first step needs to be, "Make sure your data is sorted by date, in ascending order." If the data isn't presorted, the code won't work as expected.