How to convert Column and table names into lowercase to uppercase

[Anonymous]

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

[Gabriel]

‌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.

[robert_mika]

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

[Anonymous]

HI Robert,

Yes we are loading data from hadoop to qlikview