topic Re: Find new columns in QlikView https://community.qlik.com/t5/QlikView/Find-new-columns/m-p/1258795#M859215 <HTML><HEAD></HEAD><BODY><P>You could load your tables with a wildcard like:</P><P></P><P>load * from ...</P><P></P><P>which would include new columns without knowing the fieldnames whereby I assume that your source is a kind of crosstable by which a transforming into normal datastructures is often useful, see: <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 30 Jan 2017 15:56:16 GMT marcus_sommer 2017-01-30T15:56:16Z Find new columns https://community.qlik.com/t5/QlikView/Find-new-columns/m-p/1258794#M859214 <HTML><HEAD></HEAD><BODY><P>Hi guys, I need of your help. </P><P></P><P>Suppose I have an xls file with 4 columns this month, and I load each one.</P><P></P><P>Next month I receive a new xls file, with the same four columns, plus new one.</P><P>Can I write a script to tell me that there is a new colum? </P><P></P><P>Otherwise is there a way to make the system tell me if there is one or more new columns?</P><P>Thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Find-new-columns/m-p/1258794#M859214 Anonymous 2020-11-25T16:16:04Z Re: Find new columns https://community.qlik.com/t5/QlikView/Find-new-columns/m-p/1258795#M859215 <HTML><HEAD></HEAD><BODY><P>You could load your tables with a wildcard like:</P><P></P><P>load * from ...</P><P></P><P>which would include new columns without knowing the fieldnames whereby I assume that your source is a kind of crosstable by which a transforming into normal datastructures is often useful, see: <A href="https://community.qlik.com/qlik-blogpost/3628">The Crosstable Load</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 30 Jan 2017 15:56:16 GMT https://community.qlik.com/t5/QlikView/Find-new-columns/m-p/1258795#M859215 marcus_sommer 2017-01-30T15:56:16Z