Data Modelling

[#1]

Hello,

The answer, given by the book, is made me confused.

Could you please answer this question? and share your ideas.
Thank you

[giakoum]

when two tables have exactly the same fields, QlikView autoconcatenates them.

So the above script will result in one table called Employees_US (the 1st one), which will contain records from both tables

Answer A is the correct answer

[maxgro]

you can try with a little script and check the result

Table1:

load * inline [

Field1, Field2, Field3

q,q,q,

];

Table2:

load * inline [

Field1, Field2, Field3

aq,aq,aq,

];

when 2 tables have the same number and names of the fields Qlik will concatenate the 2 tables

if you don't want this, use noconcatenate

[Peter_Cammaert · Accepted solution]

Just try it with this example code (equivalent to the DBMS script in your example):

Emplyees_US:

LOAD EmployeeID, Name, Address INLINE [

EmployeeID, Name, Address

1, Robert, Main Street

2, Sara, Fifth Avenue

3, Bill, Ocean Drive

];

Employees_UK:

LOAD EmployeeID, Name, Address INLINE [

EmployeeID, Name, Address

4, Stephen, Manor House

5, Steve, High Castle

6, Bill, Oxford Road

];

Best,

Peter

[marcus_sommer]

I haven't done it yet by myself because I haven't a similar use-case but if I some of the recent postings here understand right are there by preceeding loads no auto-concatenating even if the table-structure matched excactly a previous loaded table and therefore it would two tables with the identical fields exists and therefore synthetic keys, too which would lead to answer D.

- Marcus

[Anonymous]

Hi,

The  anwser is letter  D,because,  the  both tables  share more than one field, with the same name, then Qlikview automatically associates common fields, created a synthetic key.

Regards.

[maxgro]

I tried this on a db, 2 different tables D_DATE and D_DATE_2 and the result is

one table a

a:

LOAD

     "DATE_KEY", "DATE_ID", TIMESTAMP;

SQL SELECT

     "DATE_KEY", "DATE_ID", TIMESTAMP

FROM "IT_ADM"."D DATE";

b:

LOAD

     "DATE_KEY", "DATE_ID", TIMESTAMP;

SQL SELECT

     "DATE_KEY", "DATE_ID", TIMESTAMP

FROM "IT_ADM"."D DATE_2";

[maniram23]

Hi,

answer "A" is correct. Because auoconcatenate is applied in both table.

so that it will show first table name is a table name.

[#9]

Cevap A

iki tablonun aynı kolonları olması nedeniyle autoconcatenate yapacaktır.

bu nedenle de iki tablo da tek tablo gibi gözükecek ve ilk tablonun adını alacaktır.

bu linkten kolayca fikir sahibi olabilirsiniz.

Kolaylıklar.

[Anonymous]

I adjustment my answer,the correct answer is the letter A as mentioned, Maxgro, Mani Ram and Erhan Polat

Regards