Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anushainfy
New Contributor III

How to convert Column and table names into lowercase to uppercase

Hi All,

I want to repost my previous question clearly ,Currently we are sourcing data from oracle(CDW) in this all the table and column names are in upper case now we move this data to hadoop in which all the column and table names are changed to lowercase so, any possibility to convert lowercase column names into uppercase automatically while loading data from hadoop .

Please respond to this.

In my last post i am not clear about the issue please help me to resolve this.

Thanks in Advance

3 Replies
Gabriel
Valued Contributor II

Re: How to convert Column and table names into lowercase to uppercase

‌Hi,

You possibly can have a excel file which does renaming of all the fields name from Lower to Uppe.

Then bring this excel file in as a Mapping Table and you can use RENAME FIELD USING to rename the fields in QlikView.

Re: How to convert Column and table names into lowercase to uppercase

Are you downloading the data from Hadoop into Qlikview or first to csv/excel then to Qlikview?

anushainfy
New Contributor III

Re: How to convert Column and table names into lowercase to uppercase

HI Robert,

Yes we are loading data from hadoop to qlikview

Community Browser