Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I need to detect a date field in the QVD load, i have several fields so load the specific field not works fine, so i need a way to detect a date field automatically even if have string format because the dates are stored in different patterns
Use Alt() with a number of different patterns as shown in the Help here:
https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...
Also similar to what's discussed here
https://qlikviewcookbook.com/2019/12/parsing-non-standard-signs/
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Use Alt() with a number of different patterns as shown in the Help here:
https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...
Also similar to what's discussed here
https://qlikviewcookbook.com/2019/12/parsing-non-standard-signs/
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com