Dynamic Script to Load/Update Tables?

[benvatvandata]

Hi,

I have a script that does what I want for 1 table in my whole document... but there are a ton of tables so I'd like to figure out how to write a dynamic script to update all the tables in a similar fashion.

Basically, I have a temporary Link table (LinkNew) that holds all the primary keys in each table (i.e. %BillLineKey, %ItemKey, %SOrderLineKey, %InventoryKey, etc.), and I'm using that to update which keys/records should be included in all the new tables.

This is the part of my script I'd like to be dynamic:

Left Join(Billing)
LOAD Distinct %BillLineKey,
%BillLineKey as %BillLineKey2
Resident LinkNew;

NoConcatenate
Billing2:
LOAD *
Resident Billing
where %BillLineKey <> %BillLineKey2;

Drop Table Billing;
Drop field %BillLineKey2 from Billing2;

So the above example was for updating my Billing table... is there a way to loop through each table and do this dynamically?

Thanks,

Ben

[benvatvandata]

So just to add another example... after it updates my Billing table, it would then do the following for the next table (i.e. SOrderLine):

Left Join(SOrderLine)
LOAD Distinct %SOrderLineKey,
%SOrderLineKey as %SOrderLineKey
Resident LinkNew;

NoConcatenate
SOrderLine2:
LOAD *
Resident SOrderLine
where %SOrderLineKey <> %SOrderLineKey2;

Drop Table SOrderLine;
Drop field %SOrderLineKey2 from SOrderLine2;

Thanks,

Ben