topic Re: tLogRow does not show any output. in Talend Studio

tLogRow does not show any output.

Jedi-Habs — Sat, 16 Nov 2024 02:35:23 GMT

Hi, I have to do an inner join between two columns,one from HANA and another from MSSQL respectively. But I am not seeing any output. All the rows show up as 0's. Please see the pic attached. Do you guys have any idea what I am missing here?

Re: tLogRow does not show any output.

Anonymous — Mon, 27 Apr 2020 02:43:33 GMT

Hi
Make sure you are doing an inner join rather than left outer join (by default, it is left outer join), if the columns comes input data, print the value before tMap to check if you get expected data before join.

BTW, please insert images into your post body instead of attaching them.

Regards
Shong

Re: tLogRow does not show any output.

manodwhb — Mon, 27 Apr 2020 03:21:25 GMT

It is printing, but you are seeing 0 ,are those values directly coming from main or lookup?

Re: tLogRow does not show any output.

Jedi-Habs — Mon, 27 Apr 2020 11:12:30 GMT

Thanks. It is an inner join. And how do I print it out? I tried to see the data from just one source but seeing 0's there as well.

Re: tLogRow does not show any output.

manodwhb — Mon, 27 Apr 2020 11:26:37 GMT

@Jedi-Habs , you have mapped correctly that inner join and now from tmap connect to tlogrow and see the data what are you getting out from the console.

if you are not getting the expected data then your data may be not correct.

Re: tLogRow does not show any output.

Jedi-Habs — Mon, 27 Apr 2020 11:30:07 GMT

Thanks Manod. To your question, I think it's Main. I am doing an inner join and even though for now, I am trying to see the common elements but the eventual goal is to see rejected elements. Check the screen shot I attached in my previous reply. How do I make it to show the real values instead 0's? Thanks.

Re: tLogRow does not show any output.

manodwhb — Mon, 27 Apr 2020 11:35:01 GMT

@Jedi-Habs,since joining columns are character data type and what values are you seeing other than 0 outside of Talend? can you just read one table and see what are you seeing in Talend?

Re: tLogRow does not show any output.

Jedi-Habs — Mon, 27 Apr 2020 11:37:04 GMT

I tried just dumping the from each data source and still seeing 0's. The SQL queries run fine in HANA and MSSqlStudio and I see results there. Why not here?

Re: tLogRow does not show any output.

manodwhb — Mon, 27 Apr 2020 11:41:39 GMT

@Jedi-Habs , whatever the data is there it will show and will not change the data by its wone/ I worked with mysql it will display wah ever the data is there.

Re: tLogRow does not show any output.

Jedi-Habs — Mon, 27 Apr 2020 15:38:06 GMT

This turned out to be an issue with the data types. Once they matched, the data started showing up. The problem was the Type,DB Type mismatch in the schema definition which I had changed cause of another issue. The issue is resolved now.Thank you @manodwhb for all the advice. Appreciate it.