Discussion board where members can get started with QlikView.
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.
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.
A2 as B2,
A3 as B3,
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 ?
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
Name as NewName,
I think you can use Noconcatenate between the tables.
Hi, fields have to be renamed in some way to avoid association, if you want to avoid manual renaming you can use qualify:
//LOAD tables A, B;
// LOAD table C
Another option to avoid joins is to concatenate the rows of both tables:
concatenate (tableA) // Add rows to TableA
'TableC' as Origin // Optional field to trace where the record comes from