relation question

[#1]

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.

[#2]

noconcatenate doesn't work

.....

[phaneendra_kunc]

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;

[fkeuroglian]

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

[jagan]

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.

[#6]

hi,

Use Qualify *, function inbetween  first and second table it will take table name prefix to the field values in second table

[#7]

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?

[Anonymous]

It is because You have 2 fields with same name.

Rename the field using :

C as Example

Or use qualify C before load.

[jagan]

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.

[Anonymous]

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 ?