Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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);

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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