Hi @Heku_ It seems you are not doing the reconciliation in the Update Data correctly.You should be using recipient-id (NMSRecipients) with foreign-key/recipient-id (Archived Tracking Logs)

Hi @rvnth Have you tried using Group By recipientID with a Count(features) column? With that in place you will only need a Split activity to check if Count(features) > 1, etc.

Hi @PLundmark Adobe Campaign is case sensitive, so it seems "A0.betId" is not same for Adobe as "a0.betId".Maybe you can check your database configuration to solve it. 

Hi @rbiri You can try using the "Maximum number of propositions" condition.For extended details see: Managing offer presentation | Adobe CampaignBest  

Hi @rvnth I will suggest to transform the file format to CSV first to be sure the data is supported. Then also use a Read file from SFTP where you can have the updated file daily and read it with a Scheduler.Hope it helps!Best 

Hi @BhaskarJC I will suggest to create a Consents schema that Recipients, Leads and Dealers use.The consent records will have their own ID and just add one field to the Consents schema to filter the ones that are for each of your three schemas.Hope it helps!Best