Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

load scripting

how to retrieve row 3 from a table in a script,and assign column values ​​to variables

row<--table[2]


x<- row.fiels

1 Solution

Accepted Solutions
sunny_talwar

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

View solution in original post

6 Replies
sunny_talwar

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

Anil_Babu_Samineni

Perhaps this?

LET Var = Peek('Table2',2);

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
souadouert
Specialist
Specialist
Author

the value of first clounm for exemple

sunny_talwar

Should be able to use Peek() function

Let vVal = Peek('ColumnName', -1, 'TableName');

souadouert
Specialist
Specialist
Author

thank you sunny

sunny_talwar

No problem at all, always glad to help