topic Re: Table Join Question in QlikView

Table Join Question

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

HI Experts,

I have loaded 4 tables in my qlikview.

Eg- A, B, C and D

Tables A and B are joined using a common field which is fine.

Fields in Table C are available in Table A as well but i dont want to join Table A and Table C.

is there any way for me to avoid joining Table A and C without having to re-name the common fields.

Thanks,

Ram

Re: Table Join Question

jonathandienst — Thu, 26 Apr 2018 09:45:30 GMT

You don't have to join them if you don't want to. But I think you are referring the QV association between tables using key fields with the same name.

>>is there any way for me to avoid joining Table A and C without having to re-name the common fields.

No. Renaming the fields is how you prevent the association. Just load them with and alias, or Qualify the fields that should NOT be in the association.

For example

LOAD A1,

A2,

FROM A

LOAD A1,

A2 as B2,

A3 as B3,

FROM B

Re: Table Join Question

YoussefBelloum — Thu, 26 Apr 2018 09:45:41 GMT

Hi,

we need more details here..

are your C and D tables connected ? if yes, with which field ?

and are the table D connected with A or B ?

Re: Table Join Question

vishweshwarisun — Thu, 26 Apr 2018 09:56:15 GMT

Hi,

To avoid the joining of those field you will have to alias the common key through which they are joining in either of the table.for ex

Table1:

LOAD

ID,

Name,

Country

FROM Table1

Table2:

LOAD

ID,

Name as NewName,

City

FROM Table2

Re: Table Join Question

ravikumar89 — Thu, 26 Apr 2018 10:51:45 GMT

I think you can use Noconcatenate between the tables.

Re: Table Join Question

rubenmarin — Thu, 26 Apr 2018 11:18:11 GMT

Hi, fields have to be renamed in some way to avoid association, if you want to avoid manual renaming you can use qualify:

https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Qualify.htm

//LOAD tables A, B;

Qualify *;

// LOAD table C

Unqualify *;

Another option to avoid joins is to concatenate the rows of both tables:

TableC:

concatenate (tableA) // Add rows to TableA

LOAD ...

'TableC' as Origin // Optional field to trace where the record comes from