Space in the column name

[daez]

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,

[manodwhb]

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

[daez]

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

[daez]

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

[manodwhb]

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

[daez]

@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

[manodwhb]

@daez,first Flow wold be lke

tFixedinputflow --> tFileOutpputDelimited

[manodwhb · Accepted solution]

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

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

[daez]

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

Regards, B.

[BA621858188]

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.