topic Re: [resolved] Put a result into context variable in Talend Studio

[resolved] Put a result into context variable

Anonymous — Sat, 16 Nov 2024 13:43:27 GMT

Hi !
I have a query which gets the maximum enumerator from a AS400 table (select max(xxxx) from ...). After that, I would like to put this value into a context paramter.
Have you got and idea ?
Thanks a lot.
Kim

Re: [resolved] Put a result into context variable

c0utta — Thu, 22 Oct 2009 23:42:16 GMT

Hi Kim,
Since the result of "select max(xxxx) from ..." will only return one row, use a tJavaRow (or tPerlRow) after the t*Input.

context.count = input_row.count

Cheers,
c0utta

Re: [resolved] Put a result into context variable

Anonymous — Fri, 23 Oct 2009 07:26:40 GMT

Thanks a lot !
It works fine 😉
kim

Re: [resolved] Put a result into context variable

Anonymous — Thu, 18 Jul 2019 13:19:57 GMT

Hi, everyone!

I have a context variable RowCount, and I need to write javacode which will input row count into this variable.

this code doesn't work:

context.RowCount = input_globalMap.put("tFileRowCount_1_COUNT");

Can u help me ?