topic Re: Space in the column name in Talend Studio

Space in the column name

daez — Fri, 04 May 2018 08:53:33 GMT

Hello everyone, I'm having troubles finding a good solution for my problem. On my job (see below), I want my column name with spaces. (underscore > space )

So it should look like : Master_ID > Master ID , URL_product_picture > URL product picture .... and so on.

I checked online and we can't just rename it since its Java. Considering my job, does someone as any idea how to that ? I saw the trick with the tfixedFlowInput but I'm not sure how to do it since i have httprequest & tmap.

Kindly,

Re: Space in the column name

manodwhb — Fri, 04 May 2018 09:01:49 GMT

@daez,in the first flow create a header record using tfixedFlowInput ,and on the subjob ok from the first flow continue the your job which you specified ,and in tFileOutputDelimited check the Append option in Basic settings.

Re: Space in the column name

daez — Fri, 04 May 2018 09:12:52 GMT

Hi @manodwhb ,

I tried but i must understood wrong. I created a tFixedFlowInput with my header in. Then, i connected it to tHttpRequest with " On subjob OK " and then check the Append option in the tFile OutputDelimited. Unfortunately, it does not work. Where am I wrong?

Thanks for you time

Re: Space in the column name

daez — Fri, 04 May 2018 10:23:11 GMT

Can anyone help? I still have trouble understanding how i should do this

Re: Space in the column name

manodwhb — Fri, 04 May 2018 10:28:56 GMT

@daez,can you check the output filename is same which you were creting in header and tFileoutputDelimited ?

Re: Space in the column name

daez — Fri, 04 May 2018 10:37:58 GMT

@manodwhb I only have one output filename in my job, in the tFileOutputDelimited. I have no filename to put in the tFixedFlowinput (right?). Maybe if you get a look at what i have done you will see where i'm wrong ?

Here is my tFixedFlowInput (you can see the On SubjobOK, about warning : no schema (no idea what to put in there since i cant had space in it)

And about my tFileOutputDelimited, i checked the APPEND & unchecked the Include Header. Can have a look here though its in french.

And when i execute this, I have the exact same file than before, with no changes on header.

Really appreciate your support, regards

Re: Space in the column name

manodwhb — Fri, 04 May 2018 10:39:37 GMT

@daez,first Flow wold be lke

tFixedinputflow --> tFileOutpputDelimited

Re: Space in the column name

manodwhb — Fri, 04 May 2018 10:43:35 GMT

@daez,please check the below link to create Header part.

https://umeshrakhe.wordpress.com/tag/tfixedflowinput/

Re: Space in the column name

daez — Fri, 04 May 2018 11:00:53 GMT

Thanks for everything @manodwhb, its working now. I did some research but didnt find your link, which was really helpful.

Regards, B.

Re: Space in the column name

BA621858188 — Sun, 05 Jun 2022 17:28:46 GMT

Hi Daez,

I wanted to know the resolution. I have database as source where my column name is employee_id but in my target I want column name as employee id (Space).

Could you please help here.