topic Re: load scripting in QlikView https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438654#M611908 <HTML><HEAD></HEAD><BODY><P>thank you sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Wed, 08 Nov 2017 14:27:00 GMT souadouert 2017-11-08T14:27:00Z load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438649#M611903 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">how to retrieve row 3 from a table in a script<SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #212121; font-size: 10pt; font-family: arial, sans-serif;">and assign column values ​​to variables</SPAN></SPAN></P><P><SPAN style="color: #212121; font-size: 10pt; font-family: arial, sans-serif;">row&lt;--table[2]</SPAN></P><P><SPAN style="color: #212121; font-size: 10pt; font-family: arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #212121; font-size: 10pt; font-family: arial, sans-serif;">x&lt;- row.fiels<A></A></SPAN></P></BODY></HTML> Wed, 08 Nov 2017 13:11:33 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438649#M611903 souadouert 2017-11-08T13:11:33Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438650#M611904 <HTML><HEAD></HEAD><BODY><P>You can do this</P><P></P><P><STRONG>LOAD FIELDNAMES</STRONG></P><P><STRONG>FROM ...</STRONG></P><P><STRONG>WHERE RowNo() = 3;</STRONG></P><P></P><P>What exactly are you looking to assign to variable?</P></BODY></HTML> Wed, 08 Nov 2017 13:13:01 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438650#M611904 sunny_talwar 2017-11-08T13:13:01Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438651#M611905 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P></P><P><STRONG>LET Var = Peek('Table2',2);</STRONG></P></BODY></HTML> Wed, 08 Nov 2017 13:14:08 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438651#M611905 Anil_Babu_Samineni 2017-11-08T13:14:08Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438652#M611906 <HTML><HEAD></HEAD><BODY><P>the value of first clounm for exemple</P></BODY></HTML> Wed, 08 Nov 2017 13:51:59 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438652#M611906 souadouert 2017-11-08T13:51:59Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438653#M611907 <HTML><HEAD></HEAD><BODY><P>Should be able to use Peek() function</P><P></P><P><STRONG>Let vVal = Peek('ColumnName', -1, 'TableName');</STRONG></P></BODY></HTML> Wed, 08 Nov 2017 14:01:57 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438653#M611907 sunny_talwar 2017-11-08T14:01:57Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438654#M611908 <HTML><HEAD></HEAD><BODY><P>thank you sunny <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Wed, 08 Nov 2017 14:27:00 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438654#M611908 souadouert 2017-11-08T14:27:00Z Re: load scripting https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438655#M611909 <HTML><HEAD></HEAD><BODY><P>No problem at all, always glad to help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 08 Nov 2017 14:28:02 GMT https://community.qlik.com/t5/QlikView/load-scripting/m-p/1438655#M611909 sunny_talwar 2017-11-08T14:28:02Z