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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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