Table Join Question

[ramanarayan]

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

[jonathandienst]

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

A:

LOAD A1,

    A2,

    A3

FROM A

B:

LOAD A1,

    A2 as B2,

    A3 as B3,

    B4

FROM B

[YoussefBelloum]

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 ?

[vishweshwarisun]

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

[ravikumar89]

Hi

I think you can use Noconcatenate between the tables.

[rubenmarin]

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/Quali...

//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