Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

need to capture the data which is having the blank field in the Updated field column in the Incremental load

Hi Guys,

we Have implemented the incremental load in the Application and it is working fine ,But user is requesting to include the data which is having blank value in the updated field column,

Could please help us how to capture the blank field.

it is Very Urgent we need to update to user!!!!

michaelwadloveisfailjimhalpertafderikabghnick2009theresaahod

2 Replies
adityaakshaya
Creator III
Creator III

Hi,

You can do that using isnull function over that field and flag it. I can give you exact steps if you can help me to understand about the incremental load you are using.

Are you only loading the delta data load or updating the previous records too.

Regards,

Akshaya

jonathandienst
Partner - Champion III
Partner - Champion III

You are asking for how to modify a loadscript. I suggest that you post the script to that you can get useful suggestions.

Is Updated the field used for controlling the incremental load?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein