Overlapping field value on send in excel in Qlikview

[SunilChauhan]

Hi all,

I am getting Overlapping field value on send in excel in Qlikview for example

below table

Id ,Comment,.........................................somecolumn

1,ggggggg,..........................

2,ghdfghfh,..........................

3,mmmmmmmm,..........................

after export it show like below

Id ,Comment,.........................................somecolumn

1,ggggggg,..........................

2    ,

ghdfghfh,

3,mmmmmmmm,..........................

i mean some value from comment column showing under ID column.

Could you please help me regarding

Thanks

[madhumitha]

Hi Sunil,

Try using trim() before loading the data, and then export it.

[Anil_Babu_Samineni]

How you are going to export?

[SunilChauhan]

using XL option at right top corner of Tablebox

[SunilChauhan]

Hi,

sorry its not working!!

[tresesco]

Sunil,

Could you post a representative sample qvw?

[SunilChauhan]

exact Data i canot sahre.but some comment showing under my Id column

Id ,Comment

1,ggggggg,..........................

2, ghdfg

hfh

3,mmmmmmmm,..........................

i mean some value from comment column showing under ID column.

Could you please help me regarding

[tresesco]

See if you could replicate the same behavior with a sample data that can be shared.

[madhumitha]

Hi Sunil,

Seems like there is some newline character is in the comment section which is pushing the data into the next column.

Its really hard to identify the issue with out data.

[techvarun]

There are chances of a newline character on the data.

replace the same with Purgechar or replace function.