Hi,
in my current app, some data that is primarily forthcoming from an Excel file will be stored to qvd
=> then it will be loaded from that qvd, edited and saved back with the same name to be loaded again.
=> My issue is with fields the names of which stretch over two lines in the base_Excel. These are enclosed in square brackets if you use
the wizard to build your LOAD and cover two lines in the script.
=> I cannot just rename any such field just like that because the next time I load that qvd, QlikView will return a "field not found" error
regarding the original field_name. Also, I will eventually have to load a new base_Excel and compare it to the qvd I have which
is more difficult if I have renamed any fields.
<=> When I leave it as it is and on the GUI I try to create a textbox that just shows the contents of this field - that doesn't work because
as soon as I type an equals sign, the script_editor reports an error.
Can anyone advise me how to deal with such fields?
Thanks a lot!
Best regards,
DataNibbler