Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Command inline

when running in command line, because the number of references B 35 is not listed ?





LOAD * INLINE [
Código, Descrição
'0035', A
'35', B
'0081', C
'80', D
'0030', E
'50', F ] ;




3 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Load the contents as text:

LOAD text(Código) as Código, Descrição INLINE [
Código, Descrição
'0035', A
'35', B
'0081', C
'80', D
'0030', E
'50', F ] ;

Not applicable
Author

I'm with this same problem when I read a table in a SQL Server database. So at the time of extracting the data I have to know which fields are going to give this problem and correct at the time of extracting?
disqr_rm
Partner - Specialist III
Partner - Specialist III

You may try to do that dynamically. Have a look at logic in this nice utility for MSSQL:

http://community.qlik.com/media/p/83232.aspx