function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
anvesh@force.comanvesh@force.com 

Need Formulae for this logic?

Can the following logic be implemented – For each EXTERNAL_ID, if STATUS field is populated with value ‘T’ AND field ‘TERM_DATE’ does not equal ‘{PREVIOUS DAY’S DATE}’ exclude the record from the daily load.

JonathanBaltzJonathanBaltz

Instead of doing the formula on the EXTERNAL_ID, create a Checxbox formula field and filter your daily load based on the value of the checkbox. 

 

The formula would be AND( STATUS = 'T', TERM_DATE <> YESTERDAY)  or something like that. 
MarcPannenberg.ax1843MarcPannenberg.ax1843

What do you mean by "exclude from the daily load" and the reference to an Eternal_ID? Are you using data loader to insert or extract records?
TilluTillu

Yes using Data loader /  ETL (Informatica)