topic Re: relation question in QlikView

relation question

Fri, 19 Sep 2014 00:17:24 GMT

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.

Re: relation question

Fri, 19 Sep 2014 00:22:07 GMT

noconcatenate doesn't work

.....

Re: relation question

phaneendra_kunc — Fri, 19 Sep 2014 00:37:48 GMT

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

C as P

From Table Y;

Re: relation question

fkeuroglian — Fri, 19 Sep 2014 01:06:27 GMT

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

Re: relation question

jagan — Fri, 19 Sep 2014 01:27:14 GMT

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

LOAD

a, b, c

From TableX;

LOAD

c AS NewColumnName,

d, e,f

From TableY;

Hope this helps you.

Regards,

Jagan.

Re: relation question

Fri, 19 Sep 2014 01:36:13 GMT

hi,

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

Re: relation question

Fri, 19 Sep 2014 01:56:10 GMT

isn't there any other way , no rename 'C'

for example....

load

from Table Y;

<statement> is script statement to release relation.

is there adequate statement?

Re: relation question

Anonymous — Fri, 19 Sep 2014 01:56:42 GMT

It is because You have 2 fields with same name.

Rename the field using :

C as Example

Or use qualify C before load.

Re: relation question

jagan — Fri, 19 Sep 2014 01:59:36 GMT

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.

Re: relation question

Anonymous — Fri, 19 Sep 2014 02:20:12 GMT

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 ?