topic Excel data load-how to change column fields content in Script Editor in QlikView https://community.qlik.com/t5/QlikView/Excel-data-load-how-to-change-column-fields-content-in-Script/m-p/1051869#M930030 <HTML><HEAD></HEAD><BODY><P>Loading Excel file to QlikView, one column contains ID numbers or blank fields.</P><P>How to change the field content to<STRONG> Yes</STRONG> = column fields with a value (ID number) OR&nbsp; <STRONG>No</STRONG> = blank field</P><P>Hence every time the data is reloaded the fields in the column are replaced by the corresponding values <STRONG>Yes / No</STRONG></P><P></P><P>I want to implement this data transformation in the Script</P><P></P><P>Than you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Excel data load-how to change column fields content in Script Editor https://community.qlik.com/t5/QlikView/Excel-data-load-how-to-change-column-fields-content-in-Script/m-p/1051869#M930030 <HTML><HEAD></HEAD><BODY><P>Loading Excel file to QlikView, one column contains ID numbers or blank fields.</P><P>How to change the field content to<STRONG> Yes</STRONG> = column fields with a value (ID number) OR&nbsp; <STRONG>No</STRONG> = blank field</P><P>Hence every time the data is reloaded the fields in the column are replaced by the corresponding values <STRONG>Yes / No</STRONG></P><P></P><P>I want to implement this data transformation in the Script</P><P></P><P>Than you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Excel-data-load-how-to-change-column-fields-content-in-Script/m-p/1051869#M930030 2020-11-25T16:16:04Z Re: Excel data load-how to change column fields content in Script Editor https://community.qlik.com/t5/QlikView/Excel-data-load-how-to-change-column-fields-content-in-Script/m-p/1051870#M930031 <HTML><HEAD></HEAD><BODY><P>if(len(YourField)&gt;0,'Yes','No') as NewField,</P></BODY></HTML> Thu, 10 Mar 2016 20:39:00 GMT https://community.qlik.com/t5/QlikView/Excel-data-load-how-to-change-column-fields-content-in-Script/m-p/1051870#M930031 m_woolf 2016-03-10T20:39:00Z