Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
suppose
i have 2 tables.
one = tablename (y)
two = table name (z)
y have 3 columns a, b, c
z have 4 coumns c, d, e,f
if i use load statement in script,
auto relation ---> Y and Z
problem is i want to have no relation.
please let me know.
noconcatenate doesn't work
.....
Auto relation will happen as column name "C" is common between Y and Z table.
Rename the column name "C" in one of those tables to something else and Qlikview will not auto link.
you can do that by aliasing like
Load
A,
B,
C as P
From Table Y;
Hi, if they have the same name (C in this case) always will be auto relation between this two tables
you have to use "C as xxx" to rename C in one table and then the two tables will be disconnected
good luck
Fernando
Hi,
Qlikview automatically links the tables based on the common column name, if you don't want to link then rename Column C in one of the table like below
X:
LOAD
a, b, c
From TableX;
Y:
LOAD
c AS NewColumnName,
d, e,f
From TableY;
Hope this helps you.
Regards,
Jagan.
hi,
Use Qualify *, function inbetween first and second table it will take table name prefix to the field values in second table
isn't there any other way , no rename 'C'
for example....
<statement>
load
A,
B,
C
from Table Y;
<statement> is script statement to release relation.
is there adequate statement?
It is because You have 2 fields with same name.
Rename the field using :
C as Example
Or use qualify C before load.
Hi,
If you don't want to rename then try using Qualify *.*;
Qualify C;
Table1:
Load A,B, C from x.csv;
Table2:
Load C, D, E, F from y.csv;
Hope this helps you.
Regards,
Jagan.
Jagan,
You are right, but its important NOT use *, because in future maybe he will need to make a relstion with other table.
We dont know the size of it, and qualify to later unqualify the right fields maybe wont be productive.
So in this case, i think is better rename or qualify only the Field 'C'.
Am i right ?