Qlik Community

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rupesh632
Creator
Creator

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

rupesh632
Creator
Creator
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

rupesh632
Creator
Creator
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

rupesh632
Creator
Creator
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