Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator III
Creator III

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

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

Highlighted
MVP
MVP

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

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