Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Table Join Question

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

Tags (3)
5 Replies
Highlighted
MVP
MVP

Re: Table Join Question

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


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Champion
Champion

Re: Table Join Question

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 ?

Highlighted
Partner
Partner

Re: Table Join Question

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

Highlighted
Contributor II
Contributor II

Re: Table Join Question

Hi

I think you can use Noconcatenate between the tables.

Highlighted

Re: Table Join Question

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