Load value from xml into variable

Tue, 08 Jul 2014 15:32:18 GMT

Hi...

I have an webservice with 3 values into parameters- vClientCode,vFirstName,vLastName

the result returns by XML is Varification Code.

My Script goes like this:

vClientCode = 999;

vFirstName = 'John';

vLastName = 'Smith';

I to load into a new variable, called- vVarificationCode, the XML result.

Thank You.

Re: Load value from xml into variable

fernando_tonial — Tue, 08 Jul 2014 18:02:21 GMT

Please, put the script.

Maybe yoou try this.

// Start of [Fornecedores.xml] LOAD statements
Table:
LOAD
  FornecedorID,
    NomeEmpresa,
    NomeContato,
    Endereco,
    Cidade,
    CodigoPostal,
    País,
    Fone,
    Fax
FROM Fornecedores.xml (XmlSimple, Table is [Fornecedores/_empty_]);
// End of [Fornecedores.xml] LOAD statements

SET FornecedorID= Peek('FornecedorID');

Best Regards.

Tonial.

topic Load value from xml into variable in QlikView

Load value from xml into variable

Re: Load value from xml into variable