Can you perform a function similar to "=proper(text)" for a field of data in QlikView script?
I am looking to clear up 'Insured party' by using proper text format like in Excel.
I have over 100,000,000 lines of data and therefore cannot use the 'from' to 'to' function from an Excel spreasheet (as too many rows!) to clear this up and mapp it in the script. I have also used a .csv format and a .txt format with the 'from' to 'to' function and it still doesn't change the cases of the text for insured party in the dashboard.