Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Giovane
Creator
Creator

Upper to Lower Case - Entire Table Conversion

Hi guys...

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?

Thank you all for any tip.

 

 

1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

HI @Giovane and @edwin !

when that kind of things happens, i use excel to create the list of fields and the transformations.

Then copy paste the text  :

QFabian_0-1605307740378.png

 

QFabian

View solution in original post

5 Replies
edwin
Specialist III
Specialist III

 

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.

 

edwin
Specialist III
Specialist III

or maybe i spoke too soon

QFabian
Specialist II
Specialist II

HI @Giovane and @edwin !

when that kind of things happens, i use excel to create the list of fields and the transformations.

Then copy paste the text  :

QFabian_0-1605307740378.png

 

QFabian

View solution in original post

Giovane
Creator
Creator
Author

Thanks for your advice, Edwin. 

 

 

Giovane
Creator
Creator
Author

Thank you QFabian.  Your aswer will help me a lot. I'll use it to solve my issue.