Jacob_Weig
Contributor III
2022-04-06
05:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data load deletes rows where there are null values
I have loaded some data from my database and realized there was some inconsistencies with the actual numbers. When I investigated further, I realized that all the rows where one of my date variables was null, were deleted. The data load was done with the data load manager, so I did not write a script myself or told it to delete rows with nulls. Does someone have a clue what could be happening and how can I counteract this?
Thank you,
Marcela
558 Views
2 Replies
vikasmahajan
MVP
2022-04-07
04:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
while loading main script you can give condition like
Where your_Field not null ;
Thanks
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
522 Views
Jacob_Weig
Contributor III
2022-04-07
05:26 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @vikasmahajan ,
Wouldn't that filter out the null dates? I want to include the rows with null dates
516 Views