topic Setting table fields in date format in Data Movement & Streaming

Setting table fields in date format

Kerem — Wed, 19 Mar 2025 22:11:20 GMT

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?

Re: Setting table fields in date format

rubenmarin — Sat, 23 Mar 2024 07:46:19 GMT

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/crosstable.htm

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.

Re: Setting table fields in date format

marcus_sommer — Mon, 25 Mar 2024 09:38:42 GMT

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