topic Re: Incremental Load Help in QlikView

Incremental Load Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to implement incremental load using excel file, however facing problem with data type/date.

Max date in excel file.

However, if I try to populate max(Date) its showing me

I have attached test QVW, plz provide your suggestion.

Thank you

Re: Incremental Load Help

zhadrakas — Wed, 12 Jul 2017 11:28:49 GMT

Hello,

check your script

this should be

SET DateFormat ='MM/DD/YYYY';

Re: Incremental Load Help

kaushiknsolanki — Wed, 12 Jul 2017 11:29:47 GMT

Hi,

it is because the max which you are looking in text object is from overall data, where as the max which you are seeing excel is at Customer PO level.

So in your application if you select the customer PO as "Email ; Dated 03.07.2017" then you will see a max date which you want to see.

Regards,

Kaushik Solanki

Re: Incremental Load Help

Anonymous — Wed, 12 Jul 2017 12:00:44 GMT

Hi Tim,

I made changes as you suggested but the issue is same.

Re: Incremental Load Help

Anonymous — Wed, 12 Jul 2017 12:05:14 GMT

Hi Kausik,

I have made some changes, even deleted first column Email ; Dated 03.07.2017 just to check result but the result is same.

I have attached updated QVW file & Excel file. Plz check the script.

Please check this and let me know what could be the reason its not peeking date properly.

Re: Incremental Load Help

arvind_patil — Wed, 12 Jul 2017 13:12:59 GMT

Hi Satyendra,

Please use below code for the max date it will help you:

LOAD

max(Date([Agent-PO Date])) as [Agent-PO Date]

FROM

[..\Desktop\Order Tracking Details.xls]

(biff, embedded labels, table is [Order Details$]);

Thanks,

Arvind Patil

Re: Incremental Load Help

kaushiknsolanki — Thu, 13 Jul 2017 05:30:47 GMT

Hi,

It is because your Date field is not loaded properly.

Try below code.

LOAD Date(Date#([Customer-PO Date],'DD/MM/YYYY')) as [Customer-PO Date],

[Agent-PO],

[Agent-PO Date],

[Item Number],

[Brand Name],

[Machine- PM],

Remarks

FROM

[Order Tracking Details.xlsx]

(ooxml, embedded labels, table is [Order Details]);

Regards,

Kaushik Solanki