I am connecting the Qlik Sense to the sql server to fetch the data. The table may have the n number of columns it may vary every time in the Sql server. When I load the data from Sql Server using the Qlik load statement, When the column is present the values related to the column have to be retrieved other wise null has to be allocated to the column.
Hi petter this sounds good, but I need to derive some derived columns from the base columns that are obtained from the sql. I can achieve this using with resident load. But I want to know can I have the alternative for this
No I want to derive those in the qlik only. When I load the data in the Qlik if the column is not present it will return error. I would like to know if there is any inbuilt function in the qlik so that it automatically passes the null to the column if the column is not present. So, that there wont be any problem in deriving the additional columns.