I have a table that has a lot of fields with all sorts of data types. I only need to find values in the table that are date, but there are so many fields that doing this manually isn't useful. How can I load only the fields, that have date type data in them?
Qlik doesn't know data-types else each loaded content will be interpreted - automatically based on the set interpretations variables or with direct specified functions. Further to perform this interpretation you will need to load the data first and afterwards you may drop the unwanted data again. This means you will need at least two working-steps but probably some more and depending on the amount of fields and their variety the logics may not be trivial.
Therefore it might be better to identify the data-type already within the source - classical databases store such information within their system-tables which could be queried, too.
Beside this how many (date) fields are there? If your table is a crosstable you should seriously consider to transform it into a stream-data structure, see:
