LIB CONNECT TO 'Remedy-ODBC64 (John)';
Here as per the Qlik standards we call [Prod] is the Table name ,so i hope your Database team is created like "PROD_Qlik " it means Prod table related to Qlik Reporting tool /Table.
If i miss understand your query please correct me.
There is a script function called TableName() that returns the name of a specific table. Unfortunately, you can't use it to return the name of the table that you are currently LOADing.
As an alternative, and on condition that you can prepare a list of names of tables to extract, you could use a FOR loop to extract and tag them all at once. For example:
FOR EACH vTable IN 'PROD_QLIK', 'PROD_TABLEAU', 'PROD_BIGDATA'
LOAD '$(vTable)' AS CurrentTableName, *;
SQL SELECT * FROM "USER"."$(vTable)";
PS Why post a Qlik Sense question in a forum called "New to QlikView"? To move your discussion to New to Qlik Sense, see here: QlikCommunity Tip: How to move your discussion thread