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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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

Hi, wich type of file you have ? csv ?

gjeremy1617088143

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