Setting table fields in date format

[Kerem]

Hi,

I have so many column names as date format on my excel file but when i try to load it into qlik i get auto-script below.

How can i load all these fields in date format without editing all of them in load script?

[rubenmarin]

Hi, you can try the crosstable to load all fields using * and create one 'Date' field with all the dates values loaded in that field.

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/...

If you don't get the expected result try to upload the excel with some dummy data that shows the issue and I will try to give you the code.

[marcus_sommer]

In addition to the crosstable-suggestion remove the entire qualifying-stuff in the script because it creates much more complexity without a sensible usage.