Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
hartleyr
New Contributor III

Load data without changing case

Hi All

I'm hoping this is an easy one....

I'm loading a set of data where I need the text to remain unchanged.  For example, Grange over Sands is being loaded as Grange Over Sands, but I want it in its raw format

I am using verbatim to ignore trailing/leading spaces, but can anyone tell me what I need to use to have Qlikview not correct the data on load?

Cheers all!

1 Solution

Accepted Solutions
hartleyr
New Contributor III

Re: Load data without changing case

Thanks for your help guys.  I think I was either having a muppet moment or it was something in my comparison in Excel that has caused this as I've re-refreshed the data and it is now correct

 

7 Replies
prieper
Honored Contributor II

Re: Load data without changing case

can you please post an example?
Partner
Partner

Re: Load data without changing case

I Can't think of an example where I had this problem.
Also you can use trim() in Qlik to remove trailing and leading spaces.
Are you sure "Verbatim" isn't changing the data? No clue what this is, I only know the brand.
hartleyr
New Contributor III

Re: Load data without changing case

Hi Prieper, thanks for your response

Its a pretty basic load from Excel;

set Verbatim = 1;

LOAD
[Q Site Name]
,[B Site Name]
FROM $(vInputPath)Site Name Translation.xlsx
(ooxml, embedded labels, table is Sheet1);

STORE * FROM Sites INTO $(vOutputPath)Sites.qvd (qvd);
DROP TABLE Sites;

hartleyr
New Contributor III

Re: Load data without changing case

Hi B_knuever

Thanks for your response.  Verbatim effectively removes the data validation on leading/trailing spaces and so where QV would usually strip these out, this function allows them to be kept in.  Unfortunately, whilst QV is working as it should I am having to retain the data inconsistencies, hence why using it.  As far as I'm aware, it shouldnt effect the case.

Anything that is fully capatilised is ok, its just this one site that is being problematic  

Partner
Partner

Re: Load data without changing case

Very Odd. Have you tried without the use of verbatim. To make sure this isn't the cause?
prieper
Honored Contributor II

Re: Load data without changing case

I cannot reproduce it.
Are you sure that you are not using CAPITALIZE-function in QV?
hartleyr
New Contributor III

Re: Load data without changing case

Thanks for your help guys.  I think I was either having a muppet moment or it was something in my comparison in Excel that has caused this as I've re-refreshed the data and it is now correct