Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The answer, given by the book, is made me confused.
Could you please answer this question? and share your ideas.
Thank you
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
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
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
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
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
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.
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";
Hi,
answer "A" is correct. Because auoconcatenate is applied in both table.
so that it will show first table name is a table name.
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.
I adjustment my answer,the correct answer is the letter A as mentioned, Maxgro, Mani Ram and Erhan Polat
Regards