Is there an alternative to Generic Load to unpivot data?  I've tried using a loop to join the tables after the fact, but Qlik keeps crashing, and just says that the process was 'aborted' with no other explanation. I do have a lot of data so that could be the issue

I ultimately want to get the data in one table so then I can merge another table for comparison of the values in each table at a given point in time. Here's an example of the data. 

I need to figure out how to make the following data representation. I want to publish a table of headers containing various fields and expand the details (many fields too) for the desired headers within a single report. i'm intersted only of two levels. Can anyone help me?

We want to migrate from Qlik Sense to Qlik Cloud and connect on-premise data sources on a Linux server. However, I have only found information for Windows servers. Is it possible to use Data Gateway - Direct Access with a Linux server?

Also, I looked into the Data Gateway - Data Movement, which, if I understand correctly, moves the data sources from on-premise to cloud. This is preferably not what we want to do, but this is possible with Linux. However, only the RedHat and Amazon Linux versions were mentioned, so it wouldn't work with the Ubuntu version either?

Is there a way to make either data gateways work with Linux Ubuntu?

When upgrading the project from talend 6 to 8 with patch R202409, I am getting system routines unresolved error.

I tried importing the system routines manually but still did not detect the routines.

Is there any where would be glitch , when we migrate.

How can I overcomes this issue

Comunidad QLIK, favor de apoyarme, Me URGE

Cuento con 2 tablas en EXCEL UNA DE 51 Instructores y otra de 2070 IDs con sus evaluaciones

Cuento con 2070 registros CON ID del 1 al 2070 y sobre cada fila cuento con columnas de evaluación de Máximo 5 ID por evaluación. ejemplo el ID 1 tiene 5 instructores necesito traer en forma de filas a los 5 instructores con sus evaluaciones correspondientes. GRACIAS

Fuentes de entrada

SE REQUIERE LO SIGUIENTE

Hi Everyone,

There is a need to load the data into target at every 6-hour interval, 4 times a day. for which, have scheduled the task to stop and start with 6 hours interval.

I tried with this start-stop approach but mostly faced error while re-starting the task.

 [SQL Server]Invalid parameter passed to OpenRowset(DBLog, ...)

Already have ignoreTxnCtxValidityCheck and set it to True.

Have gone through different article present in the Qlik Community for the above error:

and caused by "If there is no access to the backups and the log has been truncated, the error is thrown, and the task fails. "

Questions:

1. does resuming the Qlik replicate incremental task captures all the pending changes from source? 

NOTE: The task restarts manually but restarting the task after this error, does not capture the changes - have analyzed the changes captured.

2. how does we ensure, the logs and backups are not truncated?

as Qlik Replicate prevents TLOG truncation by mimicking a transaction in the database, using Start transactions in the database advance option.

As long as such a transaction is open, changes that appear after the transaction started will not be truncated.

3. what does transaction means in the above statement? 

Hi everyone,

I have three fields Sector from main table, Airport Codes and Type from master table.

Sector has multiple airport codes separated by '-' and I need to map them with Airport Codes from the master table.

1. If even one of the airport code from sector is not available in Airport Codes from master table, it should give NA.

2. If even one airport code from sector matches with Airport Codes from master table and the Type is showing International, it should give International.

3. If all the airport codes from sector matches with Airport Codes from master table and the Type is showing Domestic for all the airport codes then it should give Domestic.

Any help is appreciated. 

Thanks in advance