Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

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

Re: load scripting

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

6 Replies

Re: load scripting

You can do this

LOAD FIELDNAMES

FROM ...

WHERE RowNo() = 3;

What exactly are you looking to assign to variable?

Re: load scripting

Perhaps this?

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

souadouert
Contributor III

Re: load scripting

the value of first clounm for exemple

Re: load scripting

Should be able to use Peek() function

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

souadouert
Contributor III

Re: load scripting

thank you sunny

Re: load scripting

No problem at all, always glad to help

Community Browser