topic Re: synthetic tables error in QlikView

synthetic tables error

rafael5958 — Thu, 19 Sep 2013 01:21:00 GMT

Hi all,

I have few tables but in qlikview Im using two:

Table AG:

AG.ID PK

ATEND.ID FK

Name

Number

Table ACCOUNT

ACCOUNT.ID PK

AG.ID FK

ATEND.ID FK

Name

Number

Adress, etc

They are both connected on qlikview by AG.ID and ATEND.ID, it generates a synthetic table with AG.ID and ATEND.ID.

When I do a research it shows me rows that dont exists, for example, I have same ATEND.ID in both tables, but AG.ID only in AG,

so it creates in ACCOUNT a row with AG.ID and ATEND.ID and the other fields blanked (not null, that "-" signal).

What am I doing wrong ?

Re: synthetic tables error

Thu, 19 Sep 2013 04:35:16 GMT

will you post one test app.

Re: synthetic tables error

Thu, 19 Sep 2013 04:36:46 GMT

may i know what is pk and fk

Re: synthetic tables error

Thu, 19 Sep 2013 04:43:54 GMT

try to use only one field common between two table. so in qlikview both table automatically linked.

write code like this

Table AG:

load

AG.ID ,

ATEND.ID,

Name,

Number

from table;

Table ACCOUNT:

load

ACCOUNT.ID ,

AG.ID as AG.ID_new,

ATEND.ID ,

Name as Name_new

Number as Number_new

Adress

from table;

Re: synthetic tables error

er_mohit — Thu, 19 Sep 2013 04:49:55 GMT

i think to remove synthetic and null then try to use join function i.e left join on the basis of that table where your Table AG has complete data fields if not then try to use outer join in qlikview write simply join

AG:

load (AG.ID & '|' & ATEND.ID) as Key,

AG.ID, // PK

ATEND.ID , // FK

Name,

Number

from AG;

join

ACCOUNT:

load (AG.ID & '|' & ATEND.ID) as Key,

ACCOUNT.ID, // PK

AG.ID , // FK

ATEND.ID , // FK

Name,

Number,

Adress,

from ACCOUNT;

hope it helps

Re: synthetic tables error

rafael5958 — Thu, 19 Sep 2013 11:13:45 GMT

Thank you all, I think the Mohit Sahrma way was the better one.