Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
A, B, C
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
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.
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.
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