Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sunil,
Try using trim() before loading the data, and then export it.
How you are going to export?
using XL option at right top corner of Tablebox
Hi,
sorry its not working!!
Sunil,
Could you post a representative sample qvw?
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
See if you could replicate the same behavior with a sample data that can be shared.
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.
There are chances of a newline character on the data.
replace the same with Purgechar or replace function.