qualify will rename all your columns except those you unqualify to take the name of the table.column if you are getting multiple tables means your loading and naming multiple load with the same table name so even if you qualify /unqualify you will likely still get multiple SAP. if you are planning to add data to an existing table use:
Concatenate('tablename') Load * from file;
This will add data to the existing table.
[tmp]:
noconcatenate
Load * from file1
concatenate ('tmp')
load *
from file2
qualify *;
unqualify Material, Plants;
[SAP]:
NoConcatenate
Load * resident tmp;
This will craete tmp from file 1, add file2's data to tmp, create a table for sap with all except material and plants, being rename to sap.columname result:
sap<--table
sap.year
sap.month
sap.quantity
plant
material
If you have another table that has plant, or material
they will asscociate join themselves
