Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load value from xml into variable

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.

1 Reply
fernando_tonial
Valued Contributor

Re: Load value from xml into variable

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.

Community Browser