Hi Experts..... Please correct me what i'm wrong in this, here i'm using resident load.

[vangurideepu]

The Error is like below

Please kindly correct me what i'm wrong....

Thanks in advance

[deepakkrish]

Hi

   Try this one

Temp:

Load

Customer-ID,

Month (OrderDate) as Month,

Date(OrderDate,'DD') as Day1,

Resident Orders;

Using resident load, have to use one primary key like(ID).

[m_woolf]

Maybe you are qualifying the Orders$ table?  You don't show enough script to be sure.

[avinashelite]

Do you have any QUALIFY * key word before this table is loaded ??

share the sample file will check on the same

[MK9885]

The script looks fine (whatever is visible) if there is more then can you please share full script for this tab?

It won't make much of a difference but maybe....

Change the name of OrderDate to Order_Date in Orders table.

Then maybe use the Order_Date in your resident load as well?

And if you trying to get Days out of OrderDate field then use Day(OrderDate) as Day1. Not Date(OrderDate,'DD') as Day1

Also change the Table name to [Orders] without $.

[nsetty]

can you just try once with 'OrderDate'