Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
there are three lines in your excel file ?
or one line and then three rows after load ?
regards
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
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
any solution to handle this
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