Hi everyone,

I am facing an issue as I am trying to build a flat file to import data in a software (standard format defined by the software editor). For each of my records, I have to go through several outputs I created and this order must be respected. At the moment, my job goes through the first output for all the records and then switches to the next output.

In my case, I would like it to go through each output, one by one, with one record before it switches to the next record.

How can I do this ? Please find attached a screenshot of my job.

Thanks.

Hi!, reading documentation about Qlik Web storage provider 'Google Cloud Storage', it says that you only can put data into a bucket in Qlik SAAS, are there any plans to have this in Qlik Sense Enterprise?

Storing data from your Qlik Sense app in Google Cloud Storage

You can store table data into your Google Cloud Storage bucket in the Data load editor. You can either create a new load script or edit the existing script.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Google-Cloud-storage-provider-connector.htm

Hi everyone,
I have this bar chart of the number of requests per quarter year.
There is a clear ascending linear trend that I want to visualize with a trend line. The "naive" built-in trendline from Qlik Sense is biased by the incomplete data of the current, incomplete quarter year as shown in the figure. The reasonable thing to do is to base that trend line on the years before YearStart(Today()).
I guess this is a pretty common thing, but I can't figure out how to implement this. Do you have a hint?

What I tried so far:

• Checking similar topics here and there.
• To calculate the intercept and slope of the regression line, I use Linest_B() and Linest_M().
• As X values, I use numeric value of the quarter year: (Num#(Left([Reception YearQuarter],4))+(Num#(Mid([Reception YearQuarter],7,1))-1)/4))
• As Y values, I use Aggr(Count(RequestID), [Reception YearQuarter]) over the set of Reception Dates from previous years {1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>}, or as a complete expression: Aggr(Count({1<[Reception Date]={"<$(=Date(YearStart(Floor(Today()))))"}>} RequestID), [Reception YearQuarter]).
• In a table showing Reception Year-Quarter (both text and numeric) and Count(RequestID), I succeed in correctly calculating Linest_B(Y values, X values) and Linest_M(...) as additional measures, but not Linest_B(...) + Linest_M(...)*X-value
• As a reference line this does not work either.

AggregatedSampleData:
LOAD * INLINE [
Reception Year-Quarter, Count
2021-Q1, 17871
2021-Q2, 17515
2021-Q3, 16443
2021-Q4, 19041
2022-Q1, 19297
2022-Q2, 18020
2022-Q3, 16881
2022-Q4, 19582
2023-Q1, 21232
2023-Q2, 19139
2023-Q3, 18494
2023-Q4, 21002
2024-Q1, 21784
2024-Q2, 1790

];

Tenho a seguinte situação:

Para cada registro tenho um COD, e um ano_inicio e ano Fim, preciso que crie pra cada COD, as linhas informando que ele permaneceu de ano_inicio até ano_fim.

Exemplo:

COD | ANO_INICIO | ANO_FIM

1       |  2002             | 2005

2       |  2006             | 2008

Resultado esperado:

COD | ANO_PERMANC

1       |  2002           

1       |  2003

1       |  2004

1       |  2005

2       |  2006

2       |  2007

2       |  2008

Consegui fazer quando no LOAD filtro apenas um COD, segue QVW.

I was trying to integrate Qlik with Llama ,I was using the default Meta(Amazon_Bedrock) anaytics connection in Qlik cloud.

The connection was created successfully and i used the below script for testing

QuestionsTable:

Load * Inline [

Question_ID,Question

1,"show me general ways to help boost a company's sales"
2,"what are the core concepts in accounting?"
3,"how large is the sun?"
];

[Meta]:
LOAD
[generation],
[prompt_token_count],
[generation_token_count],
[stop_reason],
[RowId]
EXTENSION endpoints.ScriptEval('{"RequestType":"endpoint", "endpoint":{"connectionname":"Meta_(Amazon_Bedrock)"}}', QuestionsTable{Question_ID,Question});

exit script


But i got an ERROR  

"  Connector reply error: grpc::StatusCode::FAILED_PRECONDITION: 'Error while converting required format. Status(StatusCode="FailedPrecondition", Detail="Error returned by endpoint: NotFound Could not resolve the foundation model from the provided model identifier.")'   " 

Any Solutions ??

Create global context variables in Talend, then call upon those variables from within a python script that talend runs. I can't figure out a way to get it to work. I have tried creating the context variables I need, adding them to a tSystem command, then my command to run the Python file looks like "python /path/pythonfile.py ${dbname} ${host} ${pw}"

when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.

Error 1: 

Stream component 'st_0_QAD_PERU' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_QAD_PERU'.
Failed to prepare sqlite statements for CAPTURE MODE
Failed to prepare statement - select confirmed_ctx from confirmations where table_id=? -  
SQLite general error. Code <1>, Message <no such table: confirmations>.

Error 2 :

Stream component 'st_0_QAD_PERU' terminated
Stream component failed at subtask 0, component st_0_QAD_PERU
Error executing command
Failed to init cdc table table 1
Unable to get column_def for context Field 0 of table 1

Attaching the logs for both Error

i build a job in talend studio, which read the csv file from the local path and load it to the DB table. and then move that file to other folder.
When i publish it to the TMC, job ran successfully  but when i see the files and table it is unable to read the files and not able to move the files to differnt folder.