Excel data load-how to change column fields content in Script Editor

[#1]

Loading Excel file to QlikView, one column contains ID numbers or blank fields.

How to change the field content to Yes = column fields with a value (ID number) OR  No = blank field

Hence every time the data is reloaded the fields in the column are replaced by the corresponding values Yes / No

I want to implement this data transformation in the Script

Than you,

[m_woolf]

if(len(YourField)>0,'Yes','No') as NewField,