topic Re: Resident Load in QlikView

Resident Load

nihhalmca — Fri, 12 Jun 2015 07:08:47 GMT

Hi All,

Table1:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Sales

2011, A, 10

2012, B, 20

2013, C, 30

];

Table2:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Rev

2011, A, 1000

2012, B, 2000

2013, X ,3000

];

Scenario:1

Table3:

LOAD Key,

Year,

Product,

Sales

Resident Table1;

Table4:

LOAD Key,

Year,

Product,

Rev

Resident Table2;

DROP Tables Table1, Table2;

If i reload this resident load is not working. It will work when i commented one filed in either table1 or table2.

How resident load behaves here.

Scenario:2

Table3:

LOAD *,

Key

Resident Table1;

Table4:

LOAD *,

Key

Resident Table2;

DROP Tables Table1, Table2;

If i reload this error will occur like "Field names must be unique with in table".

Can you please assist me how resident load behaves here.

Regards,

Nihhal.

Re: Resident Load

PrashantSangle — Fri, 12 Jun 2015 07:19:58 GMT

Hi,

for Scenario1 What error you will get???

add NoConcatenate between Table1 & Table2 then try

Table1:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Sales

2011, A, 10

2012, B, 20

2013, C, 30

];

NoConctenate

Table2:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Rev

2011, A, 1000

2012, B, 2000

2013, X ,3000

];

Regards

Re: Resident Load

robert_mika — Fri, 12 Jun 2015 07:29:04 GMT

You need to redefine your column names:

Table1:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Sales

2011, A, 10

2012, B, 20

2013, C, 30

];

Table2:

LOAD

Year&Product AS Key,

LOAD * INLINE [

Year, Product, Rev

2011, A, 1000

2012, B, 2000

2013, X ,3000

];

//Scenario:1

Table3:

LOAD Key as key,

Year as year,

Product as product,

Sales as sales

Resident Table1;

Table4:

LOAD Key as key,

Rev as rev

Resident Table2;

DROP Tables Table1, Table2;

and use only Key as KEY

as You Year product will create synthetic keys which you do not want

Re: Resident Load

nihhalmca — Fri, 12 Jun 2015 07:33:39 GMT

Hi Max,

Thanks for reply, Your are not using resident load.

Please see my post briefly.

Nihhal.

Re: Resident Load

nihhalmca — Fri, 12 Jun 2015 07:37:18 GMT

Hi Robert,

Thank for reply. You are using alias names do not change anything in script.

Please take my script, paste and run application.

Then you will come to know, what will be happening.

Nihhal.

Re: Resident Load

robert_mika — Fri, 12 Jun 2015 07:43:42 GMT

You have to use alias when using Resident

Re: Resident Load

nihhalmca — Fri, 12 Jun 2015 07:46:56 GMT

Hi Robert, is it mandatory. We can not do without alias.

Nihhal.

Re: Resident Load

rajni_batra — Fri, 12 Jun 2015 07:48:25 GMT

!Please check attached file.

Re: Resident Load

qlikmsg4u — Fri, 12 Jun 2015 07:48:31 GMT

In scenario 2 if you load like this

LOAD *,

Key

Resident Table1;

Key field is already loaded in table1 , so you can't add same field again with same name

that's why you facing error

Re: Resident Load

PrashantSangle — Fri, 12 Jun 2015 07:51:50 GMT

Hi,

You are getting this behaviour just because of table3 output is concatenated with table1 and table2 output

therefore you have to use noconcatenate between every table.

Regards.

Re: Resident Load

nihhalmca — Fri, 12 Jun 2015 08:03:02 GMT

Hi Max,

Thanks for answer, can you see at scenario 2.

Nihhal.

Re: Resident Load

nihhalmca — Fri, 12 Jun 2015 08:08:56 GMT

Thanks Rajni.

Re: Resident Load

PrashantSangle — Fri, 12 Jun 2015 08:55:56 GMT

Hi,

In scenario 2 you are doing Load *,Key Resident Table1

In this * implies all field from Table1 which are Key,Year,Product,Sales

and you also added Key field which means your query become

Load Key,Year,Product,Sales,Key Resident Table1

As you can see You are loadin same field twice therefore you are getting error which suggesting

"Field names must be unique with in table".

to avoid it you can alias one of Key field.

Hope you clear scenario2.

Regards