In URL/Expression window I have this (simplified url) and this works

='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]

I’m going to use this in 10+ places so like to put this in a Script variable

Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id

In Script

vEmpId ='[Employee Id]';

in the URL/Expression Window, the variable works

='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)

But when I tried to put that statement into the script format and I cannot figure out how to do it

varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);

varURL = ='http://mycompany.net/jump.ashx?employeeId=' &  chr(36) & (vEmpId);

Surprisingly I am getting a lot of

Thanks in advance

I have a data model including two data sources (SAP & Salesforce) - please see the attachment. SECURITYKEY is in SAP table. After applying section access, some data rows from Salesforce table disappear. How can this be fixed?

Hello all,

I'm facing a challenge getting last year sales based on a last year date we have, I have to use this date for comparison so I can't use the AddYear() or any of the system functions because of some special cases that require this logic. Basically I have my table below, and I want to write an expression for a master item (Sales LY). I've simplified the question in the below table.

if I put this master item in a table with the 3 already provided columns, the orange numbers would populate the question marks.

Appreciate your support 🙂

Hi,

We are dynamicly renaming the columns of a tDBInput. Up to now it has been a mysql where we got our data from but we have decided to move to Snowflake but when we exchange the tDBInput (mysql) to tDBInput (snowflake) the same code fails with an index outOfBounds exception where the index is -1 in an array with the length of the number of columns. After doing a java debug and stepping through the code i saw that for some reason the snowflakeInput requires the columnnames to always stay the same because for some reason it trys to look at the metadata of the first dynamic row while loading the second so the job fails after the first row. This is also true when using the jdbc connector directly via tJDBCInput

The isolated job setup looks like this:

tDBInput(Snowflake)(schema: resultset -Dynamic) ->  tJavaFlex -> tLogRow

Pseudo Code in tJavaFlex (Main):

for(Columns in resultset){

    if(columName starts with "H_"){

          rename columnName so it Starts with HS instead;

     }

}

As i said using any other tDBInput (oracle or mysql) this setup works, same code but with snowflake as the input the job explodes. Why is that and is there a workaround? (Talend Version we are using is 7.x)

Hi,

In the example of getting the impersonation access token data-get-access-token is associated with the function that fetches the access token.
If I already have the access token because I fetched it earlier, how would I format it so that it fits the variable or if I have to, set it in the function getAccessToken()?

Oi galera.

Integrei uma base de dados My SQL de um servidor local no Qlik Cloud.

Algumas tabelas consigo adicionar pelo Gerenciador de dados em outros casos aparecem a mensagem de que os dados não podem ser adicionados.

Eu acho que pode ser Timeout.

Alguém já passou por isso? Podem me dar algumas dicas, sou novato no Qlik.

Team,

I developed 2 container in which there is a  4 separate tab common in both container.

Now the request is  if i selected New user tab in First Container it should select New User tab in Second Container.

Is it possible to implement, If Yes can i get some help on this.

Thanks

Farsana

Hello all,

I am posting this relatable question many times but didn't get correct answer till now

I have 4 different columns

I created 4 different filter panes with one column each

Now I need to create a button when I click on that button all the values in 4 filter panes has to be selected at a time 

Please help anyone.

Thanks