topic Use NoConcatenate (), still create $syn1 table... in QlikView

Use NoConcatenate (), still create $syn1 table...

Thu, 04 Jul 2013 08:13:16 GMT

The following two table is not the same, i try to use keywords NoConcatenate, however, the result is not my expectation. Moreover, a $syn1 table has been created. Or if i have the case as below, i need to use QUALIFY * to solve it??

[Table_A]:

LOAD * INLINE [

Field1, Field2, Field3

A, B, C

];

[Table_B]:

NoConcatenate

LOAD * INLINE [

Field1, Field2, Field3

D, D, D

E, E, E

F, F, F

];

Any syntax error? Pls advise

Re: Use NoConcatenate (), still create $syn1 table...

Gysbert_Wassenaar — Thu, 04 Jul 2013 09:21:19 GMT

You get a syn table because you use the noconcatenate keyword. Because both tables contain fields with the same name a synthetic key is constructed for those fields. If you don't want that and still keep the tables separate you can either rename fields or use the qualify keyword to prefix some fields with the table name. That's a kind of renaming too.

Re: Use NoConcatenate (), still create $syn1 table...

er_mohit — Thu, 04 Jul 2013 09:28:45 GMT

yeah you have to use Qualify * ;on upper side

and no need of concatenate then your both table is different

if you want primary key then write

unqualify Field1;

hope it helps