topic Re: script help in QlikView https://community.qlik.com/t5/QlikView/script-help/m-p/1303980#M843389 <HTML><HEAD></HEAD><BODY><P>Maybe:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Table:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD *</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">FROM <EM>TableFile</EM> (<EM>options</EM>)</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">WHERE UPPER(Flag4) = 'Y';</SPAN></P></BODY></HTML> Mon, 24 Apr 2017 13:24:46 GMT Peter_Cammaert 2017-04-24T13:24:46Z script help https://community.qlik.com/t5/QlikView/script-help/m-p/1303979#M843388 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>I am in the script editor and loading a table file with fields. i only want data to load with certain values based on one of the fields conditions.</P><P></P><P></P><P>Custno</P><P>Flag4</P><P></P><P></P><P>i want all customers to load that Flag4 = Y&nbsp; (yes)</P><P></P><P>I did think to put a where clause but it is not working unfortunately </P><P></P><P>Sorry this may sound confusing, please ask if you need more info i am really struggling</P><P></P><P>Many Thankssss</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/script-help/m-p/1303979#M843388 aaronnayan 2020-11-25T16:16:04Z Re: script help https://community.qlik.com/t5/QlikView/script-help/m-p/1303980#M843389 <HTML><HEAD></HEAD><BODY><P>Maybe:</P><P></P><P><SPAN style="font-family: 'courier new', courier;">Table:</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">LOAD *</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">FROM <EM>TableFile</EM> (<EM>options</EM>)</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">WHERE UPPER(Flag4) = 'Y';</SPAN></P></BODY></HTML> Mon, 24 Apr 2017 13:24:46 GMT https://community.qlik.com/t5/QlikView/script-help/m-p/1303980#M843389 Peter_Cammaert 2017-04-24T13:24:46Z Re: script help https://community.qlik.com/t5/QlikView/script-help/m-p/1303981#M843390 <HTML><HEAD></HEAD><BODY><P>May be missed Single Quote like <STRONG>Where Flag = 'Y'</STRONG></P><P></P><P>Or else you could share full screen <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 24 Apr 2017 14:19:36 GMT https://community.qlik.com/t5/QlikView/script-help/m-p/1303981#M843390 Anil_Babu_Samineni 2017-04-24T14:19:36Z