I have 2 files, One is quarterly data file(A) and one is daily(B). Both are getting updated each month. I want upsert(Update and insert) operation in that. For example if  A has 10 records and B has 6 then matching record should get updated in A, if not present already in A then record should be added to it.

There is update transformation in dataflow but that does not Insert I guess.

Is this thing possible anyway in dataflow or recipe in CRM Analytics.

 @* CRM Analytics (fka Tableau CRM) *

#Einstein Analytics #Tableau CRM