Issue of missing few records with date field added in the table

[arpitchahar]

Hi Team, 

I am from 411 Locals team and we would like to raise the issue, where we are noticing of missing records when we are adding date field in the table, but when we are removing date field, these missing records are appearing. 

This date field part on same table and there is no condition is used. 

We are loading only 12 fields in the table and the date format for the date field is “M/D/YYYY”. 

We tried all sort if trouble shoot measure and failed to achieve any outcome. 

Will need your help to solve this at the earliest as its causing the variation in numbers. 

[Mark_Little]

HI,

You are going to need to share more detail if you want any assistance. We are going to need a little more understanding of the data model, Can you add before and after pictures of the table. Do you use any expressions, share the set analysis.