Variable value in your inbox

[#1]

I'm putting an inbox , but I need the value of the Inbox variable come a selected value of a field . But when I put the term in the input box value , he appears but when I store the variable it appears only the expression and not the calculated value. Could anyone help me ?

[awhitfield]

HI Rodrigo,

can you upload an example qvw please?

Andy

[#3]

Example!

[sunny_talwar]

Try this in your script (I am unable to reload and test because I don't have the source data)

LET vDatadecadastro=(Date(now(),'DD.MM.YYYY'));

Base:

LOAD CATEGORIA AS Categoria,

     [SUB CATEGORIA] as subcategoria

FROM

TESTE.xlsx

(ooxml, embedded labels, table is Plan1);

NoConcatenate

STATUS:

LOAD Evaluate(CATEGORIA) as CATEGORIA,

  Evaluate([DATA DO CADASTRO]) as [DATA DO CADASTRO],

  Evaluate(SUBCATEGORIA) as SUBCATEGORIA,

  Evaluate([CODIGO DO STATUS]) as [CODIGO DO STATUS]

Inline

  [CATEGORIA ,   DATA DO CADASTRO , SUBCATEGORIA , CODIGO DO STATUS

  $(vCategoria) , $(vDatadecadastro) , $(vSubcategoria) , $(vCodigo_STA)]

     ;  

STORE STATUS into STATUS_$(vCodigo_STA)-$(vDatadecadastro).qvd ;

DROP Table STATUS;

DENUNCIAS:

LOAD CATEGORIA,

     [DATA DO CADASTRO],

     SUBCATEGORIA,

     [CODIGO DO STATUS]

FROM

STATUS_*.qvd

(qvd);

[#5]

It gave error