Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
phil974
Contributor
Contributor
‎2013-10-23 04:19 PM

Excel file with ALT + ENTER

Hi,
I got a problem to integrate an Excel file with a cell containing a line return (LF).
TOS doesn't integrate the line. When i pass in debug mode, i see a partial row with only fields before this famous cell.
Any idea ?

I'm using TOS 5.3.1.
Labels (2)
Labels
115 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2013-10-23 04:32 PM

Are you able to downgrade the file from excel to CSV? Then use tFileInputDelimited? Converting from excel to a CSV file will save you from several excel related headaches.
115 Views
0 Likes
phil974
Contributor
Contributor
‎2013-10-23 04:46 PM
Author

It's not ideal, but why not ?
I tried but i still have the same problem, Talend splits the line.
The "ALT ENTER" appears as a LF when i open the file with an editor.
In TOS, i try to change the default line separator to CRLF ("\r\n"), but it doesn't work.
115 Views
0 Likes
Anonymous
Not applicable
‎2013-10-23 05:43 PM

Hi, I have checked this and in TOS 5.3.0 the tFileInputExcel component does not have any problems with a cell content containing line breaks.
115 Views
0 Likes
phil974
Contributor
Contributor
‎2013-10-24 08:25 AM
Author

Thks !
Effectively, with a few ohter tests, it works.
But, the data preview is a bit confusing.
115 Views
0 Likes