Hi @Techie Savy Your videos are really helpful. I want to lookup row in a table using two fileds in a CSV file, if it finds it in table I want to update another field(not used for lookup) from csv. I don't want to insert if the row doesn't exist. what is the best step to use for this purpose.
thanks Savy, great and compact videos are the best
Hi @Techie Savy Your videos are really helpful. I want to lookup row in a table using two fileds in a CSV file, if it finds it in table I want to update another field(not used for lookup) from csv. I don't want to insert if the row doesn't exist. what is the best step to use for this purpose.
try stream lookup component take data from table and csv and compare using stream lookup
use merge rows(diff) component it return flag which says identical and deleted.. use this flag variable for further analysis
thank you . will try this
created video as well on merge diff