topic excel warning message in QlikView https://community.qlik.com/t5/QlikView/excel-warning-message/m-p/1166441#M629676 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P>How can I check for columns in my excel files and retrive a warming message&nbsp; if a column doesnt exists on a list?</P><P>For exemple:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14733389041271088" jivemacro_uid="_14733389041271088" modifiedtitle="true"> <P>table1.xls</P> <P></P> <P>name1&nbsp;&nbsp; name2</P> <P>mary&nbsp;&nbsp;&nbsp; mary</P> <P>mary&nbsp;&nbsp;&nbsp; mary</P> <P>&nbsp;&nbsp; </P> <P>table2.xls</P> <P></P> <P>name2&nbsp;&nbsp;&nbsp; name3&nbsp;&nbsp;&nbsp; name4</P> <P>peter&nbsp;&nbsp;&nbsp; peter&nbsp;&nbsp;&nbsp; peter</P> <P>peter&nbsp;&nbsp;&nbsp; peter&nbsp;&nbsp;&nbsp; peter</P> <P></P> <P></P> <P>table3.xls</P> <P></P> <P>name1&nbsp; name5</P> <P>tom&nbsp;&nbsp;&nbsp; tom&nbsp;&nbsp;&nbsp; </P> <P>tom&nbsp;&nbsp;&nbsp; tom&nbsp; </P> </PRE><P></P><P>I want have on my script some array with [name1, name2, name3] and check in all my xls files and warning me that name4 on table2 and name5 on table3 were not found in the array.</P></BODY></HTML> Thu, 08 Sep 2016 12:54:47 GMT rafael5958 2016-09-08T12:54:47Z excel warning message https://community.qlik.com/t5/QlikView/excel-warning-message/m-p/1166441#M629676 <HTML><HEAD></HEAD><BODY><P>Hi everyone.</P><P>How can I check for columns in my excel files and retrive a warming message&nbsp; if a column doesnt exists on a list?</P><P>For exemple:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14733389041271088" jivemacro_uid="_14733389041271088" modifiedtitle="true"> <P>table1.xls</P> <P></P> <P>name1&nbsp;&nbsp; name2</P> <P>mary&nbsp;&nbsp;&nbsp; mary</P> <P>mary&nbsp;&nbsp;&nbsp; mary</P> <P>&nbsp;&nbsp; </P> <P>table2.xls</P> <P></P> <P>name2&nbsp;&nbsp;&nbsp; name3&nbsp;&nbsp;&nbsp; name4</P> <P>peter&nbsp;&nbsp;&nbsp; peter&nbsp;&nbsp;&nbsp; peter</P> <P>peter&nbsp;&nbsp;&nbsp; peter&nbsp;&nbsp;&nbsp; peter</P> <P></P> <P></P> <P>table3.xls</P> <P></P> <P>name1&nbsp; name5</P> <P>tom&nbsp;&nbsp;&nbsp; tom&nbsp;&nbsp;&nbsp; </P> <P>tom&nbsp;&nbsp;&nbsp; tom&nbsp; </P> </PRE><P></P><P>I want have on my script some array with [name1, name2, name3] and check in all my xls files and warning me that name4 on table2 and name5 on table3 were not found in the array.</P></BODY></HTML> Thu, 08 Sep 2016 12:54:47 GMT https://community.qlik.com/t5/QlikView/excel-warning-message/m-p/1166441#M629676 rafael5958 2016-09-08T12:54:47Z