Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist
Partner - Specialist

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.

Don't Worry, be Qlik.