Set variable from Load statement of excel document

[Lacinne]

Hi.  I have this section of code

[Inbound]:
LOAD
INVOICENO,
TRANSDATE,
TRANSTYPEID,
WHSCODE,
left(SENDER,6) as 'CUSTID',
CHARGETYPE,
CHARGEDESC,
CHARGEQTY,
"RATE",
CHARGE
FROM [lib://MyPath/*.xlsx]
(ooxml, embedded labels, table is Inbound);

I need to set variable vCustID = Inbound.CustID

Is this possible?

[MatheusC]

Hello @Lacinne

To create a variable in the script, you will insert the function:

let vCustID = Inbound.CustID;



If it helped, mark it as a solution and leave a Like

Thank you so much!

[vinieme12 · Accepted solution]

As below

[Inbound]:
LOAD
INVOICENO,
TRANSDATE,
TRANSTYPEID,
WHSCODE,
left(SENDER,6) as 'CUSTID',
CHARGETYPE,
CHARGEDESC,
CHARGEQTY,
"RATE",
CHARGE
FROM [lib://MyPath/*.xlsx]
(ooxml, embedded labels, table is Inbound);

set variable vCustID = peek( 'CustID',0,'Inbound');

Here 0 indicates value from the first row will be assigned to the variable

read more below

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunc...