data field shifting to right cell in excel file

[abhay_aggarwal]

Hi,

I have proxy to file content conversion scenario in which I have one field in which e-mail getting populated.

for some email id coimg correct

in excel file cell

<EMAIL>AA.RR@O.M</EMAIL>

but for it is getting shifting to right cell

<EMAIL>UI.MIM@O.M</EMAIL>

Please suggest

[Former Member · Accepted solution]

Hi Abhay,

Can you please provide more detail..

r u telling that cell alignment are getting change for some datas?

[abhay_aggarwal · Accepted solution]

Hi ,

I am doing the Proxy to file contennt conversion in that I have used only fieldSeparator ',' only.

and it is one to one mapping .

some data of coloum B is shifting to A for this I have used mapwithDefault with space and this also is not working?

plz suggest

Regards

[Former Member · Accepted solution]

Hi Abhay,

i think you are not getting the value in column A ( i mean values getting suppressed) , so the value of column B is shifting to A. in CC monitor check , if you are getting the tag for column A or not

You can use the function IfElse , IfExist -> map source to target , else blank to target.

[stefan_grube · Accepted solution]

Use Notpad or another text editor for viewing csv files. Excel does not make sense here.

[abhay_aggarwal]

Can anyone plz responed?

Regards