https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743172#M590453 <P>map:<BR />mapping LOAD *<BR />Inline [<BR />CUSTCode, CUSTAttribute<BR />1 ,CUSTOMER<BR />2 ,SUPPLIER<BR />3 ,INTER COY<BR />] ;</P><P>Input_Sales:<BR />LOAD *,<BR />ApplyMap('map', wildmatch( [Customer/Vendor], 'CET*','VIT*','LOA*')) as CUST_TYPE INLINE [<BR />Customer/Vendor, Customer Name,Row Total (SGD)<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,7<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,6<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />LOA01999-USD, CONVERGENT SYSTEMS (S) PTE LTD,3<BR />];<BR /><STRONG>Join (Input_Sales)</STRONG><BR /><STRONG>Load [Customer/Vendor],</STRONG><BR /><STRONG>If(Sales_Total &gt; 0,'Y','N') as Flag_Sales;</STRONG><BR /><STRONG>Load [Customer/Vendor],</STRONG><BR /><STRONG>Sum([Row Total (SGD)]) as Sales_Total</STRONG><BR /><STRONG>Resident [Input_Sales] group by [Customer/Vendor];</STRONG></P> Fri, 11 Sep 2020 13:11:56 GMT jwjackso 2020-09-11T13:11:56Z https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743165#M590452 <P>Hi</P><P>Hi All</P><P>How to Create field = Flag_Sales , using load script for those company have sales &gt;0 ?</P><P>map:<BR />mapping LOAD *<BR />Inline [<BR />CUSTCode, CUSTAttribute<BR />1 ,CUSTOMER<BR />2 ,SUPPLIER<BR />3 ,INTER COY<BR />] ;</P><P>Input_Sales:</P><P>LOAD *,<BR />ApplyMap('map', wildmatch( [Customer/Vendor], 'CET*','VIT*','LOA*')) as CUST_TYPE INLINE [<BR />Customer/Vendor, Customer Name,Row Total (SGD)<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,7<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,6<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />LOA01999-USD, CONVERGENT SYSTEMS (S) PTE LTD,3<BR />];</P><P>The expected result :-</P><TABLE width="427"><TBODY><TR><TD width="263">Customer Name</TD><TD width="100">Row Total (SGD)</TD><TD width="64">Flag_Sales</TD></TR><TR><TD>CONVERGENT SYSTEMS (S) PTE LTD</TD><TD>3</TD><TD>Y</TD></TR><TR><TD>GRAND VENTURE TECHNOLOGY LIMITED</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>SUPER COMPONENTS (S) PTE LTD</TD><TD>7</TD><TD>Y</TD></TR><TR><TD>SUPER COMPONENTS (S) PTE LTD</TD><TD>6</TD><TD>Y</TD></TR></TBODY></TABLE> Fri, 11 Sep 2020 12:41:43 GMT https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743165#M590452 paulyeo11 2020-09-11T12:41:43Z https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743172#M590453 <P>map:<BR />mapping LOAD *<BR />Inline [<BR />CUSTCode, CUSTAttribute<BR />1 ,CUSTOMER<BR />2 ,SUPPLIER<BR />3 ,INTER COY<BR />] ;</P><P>Input_Sales:<BR />LOAD *,<BR />ApplyMap('map', wildmatch( [Customer/Vendor], 'CET*','VIT*','LOA*')) as CUST_TYPE INLINE [<BR />Customer/Vendor, Customer Name,Row Total (SGD)<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,7<BR />CET00837-SGD, SUPER COMPONENTS (S) PTE LTD,6<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />VIT01610-USD, GRAND VENTURE TECHNOLOGY LIMITED<BR />LOA01999-USD, CONVERGENT SYSTEMS (S) PTE LTD,3<BR />];<BR /><STRONG>Join (Input_Sales)</STRONG><BR /><STRONG>Load [Customer/Vendor],</STRONG><BR /><STRONG>If(Sales_Total &gt; 0,'Y','N') as Flag_Sales;</STRONG><BR /><STRONG>Load [Customer/Vendor],</STRONG><BR /><STRONG>Sum([Row Total (SGD)]) as Sales_Total</STRONG><BR /><STRONG>Resident [Input_Sales] group by [Customer/Vendor];</STRONG></P> Fri, 11 Sep 2020 13:11:56 GMT https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743172#M590453 jwjackso 2020-09-11T13:11:56Z https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743174#M590454 Thank you sir<BR /> Fri, 11 Sep 2020 13:17:05 GMT https://community.qlik.com/t5/QlikView/How-to-Create-field-Flag-Sales-using-load-script-for-those/m-p/1743174#M590454 paulyeo11 2020-09-11T13:17:05Z