Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Employee
Employee

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.