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

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 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. 

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 all,

I need to include a test in a set analysis. The expression that is not in bold works fine. I just need to include a condition now, i.e I need to sum the sales when  weeks_left_to_event was a smaller number than current_weeks_left_to_event

=Rangesum(Above(Sum({<year_event=, weeks_left_to_event<={"current_weeks_left_to_event"} ,month_event=, event_code=p(previous_event_code), event_to_compare=, event_name= >} quantity), 0, RowNo()))

Any help much appreciated!!

Olá.

Por favor, há alguma solução de somase para o caso?

Tenho uma tabela com campo "NF", "NF vinculada", "Operação" e "Frete".

Operação há dois valores "Receita" ou "Remessa".

O valor do frete está ligado às notas de "remessa", mas preciso trazer a soma dos fretes junto às respectivas notas de "Receita".

Há menção da respectiva nota de "receita" para cada nota de "remessa".

Obrigado.

I have created a bar chart with data that drills down. I am having problems with calculations in that chart. There are two filters, the bigger one is sports and the smaller one is athletes. Given the 5 biggest athletes in a few major sports, I want the chart to show a % of pay each of those athletes gets out of the sum of all 5 athletes.

My current code looks something like this:

Sum(Athletes_money)/sum(total Athletes_money)

This works when a specific sport is chosen, but when no filter is chosen and the bar chart shows all sports separate, the individual athletes money is divided by all of the athletes that are in the filter. Is it possible to make the denominator the total of just the athletes sports grouping instead of all athletes?

I have a table with 100 columns

I want to check for column 1 = 'ID001' if the other 99 columns has a certain date value say '2025-01-01'

But my code is throwing the error fieldname not found in the for loop...

what i did

// first filter column 1 for ID001

[TEST]: NoConcatenate LOAD Distinct * Resident[MAIN_TABLE] where column1='ID001';

// Loop to check for date value =  '2025-01-01' if have flag as 1

For f = 1 to NoOfFields('TEST')
LET F1 = FieldName($(f), 'TEST');
[Fields]:
Load distinct FieldName($(f), 'TEST') as Field, If(Date(Floor($(F1)))=Date(Floor(' 2025-01-01')),1,null()) as check
AutoGenerate 1;
Next f
DROP Table[TEST];

Any idea how to solve? Thanks in advance!