Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

relation question

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.

9 Replies
Not applicable
Author

noconcatenate doesn't work

.....

phaneendra_kunc
Partner
Partner

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
Partner
Partner

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
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

hi,

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

Not applicable
Author

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
Not applicable
Author

It is because You have 2 fields with same name.

Rename the field using :

C as Example

Or use qualify C before load.

jagan
Luminary Alumni
Luminary Alumni

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
Not applicable
Author

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 ?