Incremental load prob

[nikhilgarg]

Hey,

I am trying to implement the incremental load but for incremental tab , i should get final table containing data whose date > vMaxdate.

But i ma getting whole data.

Can someone looks into it. I have attached app and excel with it.

Thanks

[Anonymous]

Hi

LOAD Id,

     Name,

     Age,

     Date

FROM

(ooxml, embedded labels, table is Sheet1)

Where Date> $(vMaxDate);

  vMaxDate =Date('25-08-2015') in variable overview.

It'll fetch only one record .

Thanks

[xavieravinson]

Hi,

Please check the application,

In Peek you were using table2 and table3.

you are using resident If all the fields are same it will automatically concatenate.

I have Created a Junk. Check the application.

[nikhilgarg]

Hi ,

Thanks for your reply but i don't understand why you commented out Tranformation script.

Also, in my file for incremental Table i ma getting whole data instead of only daya matching condition:

where Date > $(vMaxDate)

bcoz , $(vMaxDate) is giving value 1992 and not 2015-09-14. And vMaxDate gives 2015-09-14.

But when i use condition:

where Date > vMaxDate ; it is giving error that vMaxDate field not found

Is there way to rectify this ?

[nikhilgarg]

Hi ,

Thanks for your reply .

But, in my file for incremental Table i ma getting whole data instead of only daya matching condition:

where Date > $(vMaxDate)

bcoz , $(vMaxDate) is giving value 1992 and not 2015-09-14. And vMaxDate gives 2015-09-14.

But when i use condition:

where Date > vMaxDate ; it is giving error that vMaxDate field not found

Is there way to rectify this ?

[nikhilgarg]

Hey,

Now it is working fine as i have used:

where Date > '$(vMaxDate)'

Thanks

[nikhilgarg]

Hey,

Now it is working fine as i have used:

where Date > '$(vMaxDate)'

Thanks

[Anonymous]

Hi NikhilGarg,

You mentioned that you have problem in incremental load tab so i worked on the same tab.

Thanks

[xavieravinson]

Hi

   I think your data in excel sheet is in text format.

Thanks & Regards,

XavieRavinson