topic Re: data coming in two lines in Integration, Extension & APIs

data coming in two lines

Anonymous — Wed, 18 Jul 2018 10:15:36 GMT

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

ogautier62 — Wed, 18 Jul 2018 10:28:46 GMT

Hi,

there are three lines in your excel file ?

or one line and then three rows after load ?

regards

Anonymous — Wed, 18 Jul 2018 10:45:52 GMT

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

on the way to journey. distance 1200 km

Anonymous — Wed, 18 Jul 2018 10:49:54 GMT

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 — Wed, 18 Jul 2018 11:24:07 GMT

any solution to handle this

ogautier62 — Wed, 18 Jul 2018 12:31:57 GMT

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