1. You could use a FOR EACH loop to extract data from the initial table that relates to a particular client. For example, imagine that you have clients ABC DEF and GHI, then you can add something like this to your second script tab:
FOR EACH vClient IN 'ABC', 'DEF', 'GHI'
[$(vClient)_Facts]:
NOCONCATENATE LOAD * RESIDENT InitialFacts
WHERE Client = '$(vClient)';
NEXT
You will still have to make sure that you're not creating a gigantic synthetic key because of all fields in the three tables having the same name. That's why the QUALIFY/UNQUALIFY statements were invented. They are very useful.
2. LOAD RESIDENT and NOCONCATENATE are two different things
LOAD RESIDENT is a statement that instructs the script engine to create a new table or add to an existing table and use a RESIDENT table as data source (in contrast to for example LOAD FROM).
NOCONCATENATE is a prefix that can be used with any LOAD statement to block the script engine from adding the loaded records to an existing table that looks the same (autoconcatenate)
As you can see in the first example, NOCONCATENATE and LOAD RESIDENT can be used together without any problem. In this example, we use it to force the creation of a new table during every loop although we load the exact same set of columns over and over.
Best,
Peter
