topic Re: How use a function in load * inline? in QlikView

How use a function in load * inline?

dcvitoria — Thu, 27 Apr 2017 14:07:58 GMT

Hi everyone.

I have a (simple) question: how use a function in load * inline, like this:

LOAD * INLINE [Data, Arquivo, Tipo, Mensagem

Now(), DocumentName, $(vTipoLog), $(vMensagemLog)];

Or only with variables?

Thanks!

Re: How use a function in load * inline?

vishsaggi — Thu, 27 Apr 2017 15:39:25 GMT

What is that you are getting when you run this Load?

Re: How use a function in load * inline?

el_aprendiz111 — Thu, 27 Apr 2017 16:07:06 GMT

Hi,

LET vNow                  = Today();
LET vDocumentName         = DocumentName();
LET vTipoLog              = DocumentPath();
LET vMensagemLog          = 'MyMessage';

LOAD * INLINE
[Data, Arquivo, Tipo, Mensagem
$(vNow), '$(vDocumentName)', '$(vTipoLog)', '$(vMensagemLog)'
];

EXIT Script;

Re: How use a function in load * inline?

Peter_Cammaert — Thu, 27 Apr 2017 16:13:54 GMT

The part between square brackets of a LOAD INLINE is an explicit multi-line string. Nothing inside will be handled by he expression evaluator. $-sign substitution will be executed as expected however, as shown in the example by Fer Fer.

But why use an INLINE if you can do it like this?

LOAD Now() AS Data,

DocumentName() AS Arquivo,

'$(vTipoLog)' AS Tipo,

'$(vMensagemLog)' AS Mensagem

AUTOGENERATE 1;

Re: How use a function in load * inline?

dcvitoria — Thu, 27 Apr 2017 20:49:34 GMT

Thank you... the others answers work too, but your working in my format...

SUB gerarLog(vTipoLog, vMensagemLog)

Teste:

LOAD Now() as Data,

DocumentName() as Arquivo,

'$(vTipoLog)' as Tipo,

'$(vMensagemLog)' as Mensagem,

OSUser() AS Usuario,

ComputerName() as Maquina

AUTOGENERATE 1;

STORE * FROM Teste INTO ;

DROP TABLE Teste;

ENDSUB;