Discussion board where members can get started with Qlik Sense.
Can any one Please help me on this.
From the below script how to pass QLIK from Table name into a New Application Field.
LIB CONNECT TO 'Remedy-ODBC64 (John)';
Please help me on how to do this.
Thanks in advance.
Go to Solution.
FOR EACH vTable IN 'PROD_QLIK', 'PROD_TABLEAU', 'PROD_BIGDATA'
LOAD SubField('$(vTable)', '_', 2) AS CurrentTableName, *;
SQL SELECT * FROM "USER"."$(vTable)";
Don't forget to move your discussion.
View solution in original post
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:
LOAD '$(vTable)' AS CurrentTableName, *;
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
Qlik already have a standard system field
Thank you.. Its working..
I have moved to Qliksense.