Is it possible to change from upper to lower case, at just one time, using a unique command, without convert fields one by one, form upper to lower case, as I load a table?
i have two data sets, both with the same tables and the same fields, but in one of them the types are upper case written, and in the other, lower case. I need to concatenate these two data sets, but, before do that, I need to proceed data conversion, from upper to lower case. Instead of using "as", or even "lower" command, each field, one by one, is there another way, less stressful, to do that?
unfortunately, i dont think the function you are looking for exists as as single function can automatically apply to all fields in a table as some table could have date and number fields. so to keep your DM clean, transform it first then save to a QVD. alternatively, transform it outside of QlikView in your ETL.