Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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;
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
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