Discussion Board for collaboration related to QlikView App Development.
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.
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
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
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
a, b, c
c AS NewColumnName,
Hope this helps you.
isn't there any other way , no rename 'C'
from Table Y;
<statement> is script statement to release relation.
is there adequate statement?
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 ?