Load data without changing case

[hartleyr]

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!

[prieper]

can you please post an example?

[bramkn]

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]

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]

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  

[bramkn]

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

[prieper]

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

[hartleyr · Accepted solution]

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