Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables loaded already, table1, table2.
Now want to resident load field [store name] from table1, another field [month] from table 2,
what is the correct syntax? thanks.
May be this:
NewTable:
LOAD CommonFields
[Store Name]
Resident Table1;
Join (NewTable)
LOAD CommonFields
Month
Resident Table2;
May be this:
NewTable:
LOAD CommonFields
[Store Name]
Resident Table1;
Join (NewTable)
LOAD CommonFields
Month
Resident Table2;