I want to concatenate two tables together like this;
Table1;
LOAD
Field1,
Field2
from Table1;
Concatenate (Table1)
LOAD
FieldA as Field1,
FieldB as Field2
Resident Table2;
But when I check Table1 after concatenation the fields are named as Table2-56.Table1.Field1
Second issue is if I just state the field name in the concat load its saying field not found, had to change it to 'Table2.FieldA as Field1' before it worked and even then it doesn't appear right on the table after.
Don't know if what I'm trying to say is clear enough, what could be the cause of this?
