topic Re: Using Resident for 2 tables in QlikView

Using Resident for 2 tables

Anonymous — Tue, 19 May 2015 09:37:08 GMT

Hi Friends,

I have 2 tables as Table A and Table B with similar columns.

[Full Name],

[First Name],

[Last Name],

[User ID],

Office,

City,

State,

Country,

[Country Code],

Company,

[Region]

We can use Resident like below.

Load

[Full Name],

[First Name],

[Last Name],

[User ID],

Office,

City,

State,

Country,

[Country Code],

Company,

[Region]

Resident Table A;

But is it possible to include Table B to the above Resident call?

Re: Using Resident for 2 tables

NareshGuntur — Tue, 19 May 2015 10:21:23 GMT

Vijay,

If both the tables have similar columns, then concatenate them and use one resident load.

Two tables can't be loaded with one Resident call.

Cheers,

Naresh

Re: Using Resident for 2 tables

Anonymous — Tue, 19 May 2015 10:28:21 GMT

Is the below correct?

Table ABC

Load....

From...Table A;

CONCATENATE

Load....

From...Table B;

NewResident:

Load

[Full Name],

[First Name],

[Last Name],

[User ID],

Office,

City,

State,

Country,

[Country Code],

Company,

[Region]

Resident Table ABC;

Re: Using Resident for 2 tables

jagan — Tue, 19 May 2015 10:32:54 GMT

Hi,

Try like this, you can use concatenate for merging two tables (similar to Union All in SQL)

Data:

SELECT

'TableA' AS Source

FROM TableA;

Concatenate(Data)

SELECT

'TableB' AS Source

FROM TableB;

Hope this helps you.

Regards,

Jagan.

Re: Using Resident for 2 tables

Tue, 19 May 2015 10:42:59 GMT

An automatic concatenation will occur if the fields are the same. If you dont want to concatenate, you can force so. by using no concatenate. Keep in mind that this will cause the two tables to associate on more than one field as they hold the same name. for table B use The qualify or rename fields as desired.

so your resident call will be like the below:

Qualify *;

Unqualify [User ID]; (if you think the two tables would be associated by the user id field)

TableB:

no concatenate Load

[Full Name],

[First Name],

[Last Name],

[User ID],

Office,

City,

State,

Country,

[Country Code],

Company,

[Region]

Resident Table A;

Re: Using Resident for 2 tables

NareshGuntur — Tue, 19 May 2015 10:43:41 GMT

Yes. It is correct.

But add one more field as Jagan suggested so that it'll be easy for you to classify the data.

TableABC:

Load....,

'TableA' as TableName

From...Table A;

CONCATENATE

Load....

'TableB' as TableName

From...Table B;

NewResident:

Load

[Full Name],

[First Name],

[Last Name],

[User ID],

Office,

City,

State,

Country,

[Country Code],

Company,

[Region]

Resident Table ABC;

Cheers,

Naresh

Re: Using Resident for 2 tables

Tue, 19 May 2015 10:52:56 GMT

we can't take resident of a table with same no. of field.

Re: Using Resident for 2 tables

Anonymous — Tue, 19 May 2015 10:53:26 GMT

Thanks friends..