This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
data is coming in two line when exported the data in excel sheets due to the source file issue
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
there are three lines in your excel file ?
or one line and then three rows after load ?
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
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
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