Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add unique identifier during load

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]
;

                     
LET QVId = 0;

LET n = NOOFROWS('COMPANIES');
FOR i = 1 TO n
LET vC = FIELDVALUE('COMPANY',i);

$(vC)ACTIVITY:

          LET m = NOOFROWS('DATABASES');
          FOR j = 1 TO m
          LET vDB = FIELDVALUE('DATABASE',j);


LOAD
  UNIQUE IDENTIFIER AS QVId,
          *
FROM
$(vC)_DC_$(vDB).QVD (QVD)
WHERE NOT EXISTS('KEYCoHiAc', Source & TruckId & ShiftDate & ShiftNb & TripSequenceNb & SequenceNb & SubSequenceNb & Activity & SiteId & StorageId & MaterialId);


LET QvId = PEEK('QVId');

NEXT

STORE $(vC)ACTIVITY INTO $(vC)ACTIVITY.QVD (QVD);
DROP TABLE $(vC)ACTIVITY;

NEXT

DROP TABLES COMPANIES, DATABASES;

0 Replies