topic Re: Case Sensitive Table and Column Names in QlikView

Case Sensitive Table and Column Names

Thu, 29 May 2014 09:28:15 GMT

I have multiple versions of a database having different case of column and table names. I want to use single model for all, but Qlik View is case sensitive

I used Force Case Lower, it worked fine but is also Lowered the case of my data.

I there any solution for that.

Regards

Rizwan

Re: Case Sensitive Table and Column Names

Thu, 29 May 2014 09:32:26 GMT

Hi Rizwan,

QlikView standard is to convert all your data to upper case. Which in your case will work fine for you.

Regards,
Marius

Re: Case Sensitive Table and Column Names

marcus_sommer — Thu, 29 May 2014 09:34:45 GMT

You could use for this MAPPING and the RENAME-statement - in help and here in forum are examples for this.

- Marcus

Re: Case Sensitive Table and Column Names

Thu, 29 May 2014 11:03:48 GMT

I think I am unable to clear my question. Let me rephrase it

I am working on a Product (our local ERP)

We have many clients using our ERP. We want to build a data model on Qlik View for our different customers.

In database I have one table si_customergroup having a field name cstg_code as primary key.

In few databases the above mentioned is SI_CustomerGroup and fields name is cstg_Code

When I Reload it executed fine on one, but gives error on other.

I have used Force Case Lower command and it worked perfectly fine, but it is also changing case of my data to lower case which I do not want.

Regards

Rizwan

Re: Case Sensitive Table and Column Names

marcus_sommer — Thu, 29 May 2014 11:32:14 GMT

You couldn't it load in one load. You need either several loads with manually adjustments (field1 as FIELD1) or per mapping and rename (it's recommend if you have many tables/fields) or you must create a variable load-statement in a loop (it's not trivial).

- Marcus