Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
mgoel
Contributor
Contributor

convert all columns data to upper case

I have an input file having 300+ columns in it. I have to convert all of my data to upper case. do we have any shortcut to do it. I am a beginner in Talend. Kindly help

Labels (3)
2 Replies
gjeremy1617088143
Master
Master

Hi, wich type of file you have ? csv ?

gjeremy1617088143
Master
Master

if yes you can use tFileInputRaw, you convert the input to string then in a tjavarow or tmap you can use  StringHandling.UPCASE(your string) then you write it with tFileOutputRaw.

Then you can read the new created file with everything in uppercase