I'm trying to add an unique identifier to each record during load. Since I'm combining various data source I need a variable to keep track of this identifier. Below the script I have without the identifier. So I need a way to update QVId during the load. Again your help is very much appreciated!
COMPANIES: ///Create table containg file names for loop, companies and qualifiers LOAD * INLINE [COMPANY FUEL GAS];
DATABASES: LOAD * INLINE [DATABASE CONFIRMED HISTORY ACTIVITY];
LETQVId = 0;
LETn = NOOFROWS('COMPANIES'); FORi = 1 TOn LETvC = FIELDVALUE('COMPANY',i);
$(vC)ACTIVITY:
LETm = NOOFROWS('DATABASES'); FORj = 1 TOm LETvDB = FIELDVALUE('DATABASE',j);