Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ?
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
Hi
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;
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