topic Re: Load data without changing case in QlikView

Load data without changing case

hartleyr — Sat, 16 Nov 2024 21:38:06 GMT

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!

Re: Load data without changing case

prieper — Wed, 09 Jan 2019 10:17:19 GMT

can you please post an example?

Re: Load data without changing case

bramkn — Wed, 09 Jan 2019 10:19:49 GMT

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.

Re: Load data without changing case

hartleyr — Wed, 09 Jan 2019 10:23:54 GMT

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;

Re: Load data without changing case

hartleyr — Wed, 09 Jan 2019 10:28:05 GMT

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

Re: Load data without changing case

bramkn — Wed, 09 Jan 2019 10:31:27 GMT

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

Re: Load data without changing case

prieper — Wed, 09 Jan 2019 10:45:45 GMT

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

Re: Load data without changing case

hartleyr — Wed, 09 Jan 2019 11:01:33 GMT

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