Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

data coming in two lines

Hi Expert,

data is coming in two line when exported the data in excel sheets due to the source file issue

col1      col2

   1    on the way to journey.

          distance 1200 km

  2      journey completed

  3      new journey new1

tried trim function not working...it has to be in one line

thanks

5 Replies
ogautier62
Specialist II
Specialist II

Hi,

there are three lines in your excel file ?

or one line and then three rows after load ?

regards

Anonymous
Not applicable
Author

yes 2 lines in excel..when i loaded it and trying to export it ... it should come in  2 rows... it should be in one row only

like

on the way to journey.  distance 1200 km

Anonymous
Not applicable
Author

sorry this is the excel file only...how to take in one row this thing in qlik sense so that while exporting only it should come in one row

col1      col2

   1    on the way to journey.

          distance 1200 km

  2      journey completed

  3      new journey new1

Anonymous
Not applicable
Author

any solution to handle this

ogautier62
Specialist II
Specialist II

you have a carriage returl line feed,

it's surely char(10)

so in load do :

replace(col2,chr(10),' ') as col2

if it's not that, share your three lines of excel