Incremental Load Help

[Anonymous]

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

[zhadrakas]

Hello,

check your script

this should be

SET DateFormat ='MM/DD/YYYY';

[kaushiknsolanki]

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

[Anonymous]

Hi Tim,

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

[Anonymous]

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.

[arvind_patil]

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

[kaushiknsolanki]

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