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

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

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

The Error is like below

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

Thanks in advance

deepakkrish — Thu, 03 Nov 2016 15:58:22 GMT

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 — Thu, 03 Nov 2016 16:24:39 GMT

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

avinashelite — Thu, 03 Nov 2016 16:26:19 GMT

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

share the sample file will check on the same

MK9885 — Thu, 03 Nov 2016 16:58:11 GMT

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 — Wed, 09 Nov 2016 20:41:13 GMT

can you just try once with 'OrderDate'