insert data into merged cell of excel file

[Anonymous]

Hi All,

I am trying to insert data into a excel file which have some merged cells.

Scenario:

data present in file :

Testing Orders		Testing2 Orders
Date	Orders received	Orders sent to WTX	Orders sent to PDP	Comments	Orders sent to PDP	Orders sent to PDP	Comments
Waiting for PDP response	PDP response received	Waiting for PDP response	PDP response received
02/09/2028(records found  on 3rd September 03.57 PM IST))	347	347	753	47		2352	2	2350
02/09/2028(records found  on 3rd September 03.57 PM IST))	408	407	232	753		75	25	750
03/09/2028(records found  on 4th September 03.24 PM IST))	235	235	247	228		294	29	293

data I am trying to insert/append :

24/09/2018(records found  on 24th September 05:45 AM IST))    1714    1617    409    1208        3770    22    2264

--------------------

when ever I am trying to do so , data inserted looks like this:

Testing Orders		Testing2 Orders
Date	Orders received	Orders sent to WTX	Orders sent to PDP	Comments	Orders sent to PDP	Orders sent to PDP	Comments
Waiting for PDP response	PDP response received	Waiting for PDP response	PDP response received
02/09/2028(records found  on 3rd September 03.57 PM IST))	347	347	753	47		2352	2	2350
02/09/2028(records found  on 3rd September 03.57 PM IST))	408	407	232	753		75	25	750
03/09/2028(records found  on 4th September 03.24 PM IST))	235	235	247	228		294	29	293
24/09/2018(records found  on 24th September 05:45 AM IST))	1714	409	1208		3370	22	2264

please check the snap shots of the file and talend job in attachments

[manodwhb]

@amit_dev_d9,it could be the space issue that i see in the bleow value there is more space between 1280 and 3770,when compared with other spaces.

data I am trying to insert/append :

24/09/2018(records found  on 24th September 05:45 AM IST))    1714    1617    409    1208        3770    22    2264

[Anonymous]

Hi Manodwhb,

Thanks for pointing out cell "B". I realized the same yesterday after posting my problem. So I added null column and tried that again . It didn't work .

Here is my workaround until I find a proper solution.

Note : I have ticked the below options :

1) Append existing file

2) Append existing sheet

3) Is absolute Y pos

in "first cell X"  value is changing

toracleinput --> thashoutput

|

thashinput --> tMap -->tFileOutputEcel (map data for first six columns including b as null and 6th column will be merged cell)  "first cell X"= 0

|

thashinput --> tMap -->tFileOutputEcel (this is mapped with 7th 8th and 9th cell , actually I left 7th cell as I am supposed to leave it blank) "first cell X"= 2

 |

thashinput --> tMap -->tFileOutputEcel (10 th column is mapped that is again a merged cell) "first cell X"= 0