topic Re: How to change column name? in Talend Studio

How to change column name?

shalinim1 — Sat, 16 Nov 2024 01:12:47 GMT

To record the logs of components. I have used tStatCatcher--> tjavaflex--> tfileoutputdelimited.

I want to change the columns name of tstatcatcher,s schema when it is loaded to

tfileoutputdelimited.

In tjavaflex I tried as,

row2.Date_Time=row1.moment;

row2.pid=row1.pid;

row2.project=row1.project;

Its loading data only for pid and project columns. The Date_time colmn is null in the output file.

How to deal with this?

manodwhb — Thu, 29 Oct 2020 07:32:46 GMT

@Shalini M , you can not change in the tstatcatcher,you have to change after tstatcatcher by using tjavaflex or tjavarow or tmap.

Thanks,

Manohar

shalinim1 — Thu, 29 Oct 2020 08:28:40 GMT

@Manohar B I've changed the columns in tjavaflex component. And connected to the output file.

manodwhb — Thu, 29 Oct 2020 09:05:51 GMT

@Shalini M ,Is it working?

Thanks,

Manohar

shalinim1 — Thu, 29 Oct 2020 09:15:44 GMT

No @Manohar B, The changed name column was null. The data was not loaded.

Prakhar1 — Thu, 29 Oct 2020 10:57:06 GMT

did yo write the code in the "Main Code" block of tJavaFlex?

shalinim1 — Thu, 29 Oct 2020 11:05:22 GMT

@prakhar dubey I wrote the code in 'start code'. But now I have changed to 'main code' block and it worked. Thank you. 🙂

Prakhar1 — Sat, 31 Oct 2020 12:27:04 GMT

@Shalini M your welcome 🙂