topic Re: Load fieldname from excel in date format in QlikView

Load fieldname from excel in date format

berstrom — Sat, 16 Nov 2024 03:05:18 GMT

Hey!

How can I convert the fieldname, which is in date format in excel into qlikview date format as it shows just the number format? To be clear I do not want the whole field to be converted into the date format but just the field name since in excel the datat looks like this:

31.12.2010
70,7
80,9
....

with the date being the fieldname. Therefore something like date(FieldName, 'DD.MM.YYYY') as FieldName does not work out for me.

I'd appreciate any help!

Best regards

Re: Load fieldname from excel in date format

marcus_sommer — Fri, 05 Jul 2019 11:45:52 GMT

It's not possible to format or change a fieldname with any kind of functions within the load but it's possible to rename a field with an alias-statement or simple: Field1 as FieldXYZ. Also it's possible to use a mapping table to rename multiple fields at a stroke - such a table could be also generated with a loop over fieldnames, checking their values and ajusting them like needed.

But I assume that there is a much easier way for you - especially if I think on your question from yesterday - that your data-source is a crosstable which could be easily transformed with The-Crosstable-Load.

- Marcus

Re: Load fieldname from excel in date format

berstrom — Mon, 08 Jul 2019 06:13:49 GMT

Hey, thanks a lot for the answer! Cross load really seems to be what I needed!