Hi,
You can resolve synthetic key by renaming fields which having same name in both table ,
It will create when fields from data tables are common more than one field
Tbl:
A,
B
from source;
Tbl2:
A,
B
from source;
It will create synthetic table with A & B fields for removing synthetic key you need to follow below approach,
Tbl:
A,
B
from source;
Tbl2:
A,
B as B_new
from source;
HidePrefix :
All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.
Example:
set HidePrefix='_' ;
If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.
Example:
set HidePrefix='_' ;
LOAD
ID AS _Key
'
'
FROM DataSource;
Now _Key is not visible in the Fields listbox, if you want to see this column then you need to select Show System Fields option.
