topic Command inline in QlikView

Command inline

Fri, 06 Nov 2009 08:20:00 GMT

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 ] ;

Command inline

disqr_rm — Fri, 06 Nov 2009 08:23:29 GMT

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 ] ;

Command inline

Fri, 06 Nov 2009 08:28:16 GMT

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?

Command inline

disqr_rm — Fri, 06 Nov 2009 09:01:40 GMT

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