Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to load a table from the database and one of the columns has a dollar sign something like "TotalSales$K". qlikView fails to read this column because of the dollar sign. Does anyone know how I can load this column without changing the database?
thanks,
Manoj Agrawal
Thanks for the reply but since $ is a system field QlikView ignores it and returns the error "field [TotalSales] not found".
regards,
Manoj
Hi blackmon,
Could you show the actual script.
I've just tried do load data from excel with $-sign in the field. It looks ok.
Regards,
Sergey
Hi Sergey,
My bad. The field is "TotalSales$(K)" and it errors out.
thanks,
Manoj
Manoj,
could you show the actual script?
Regards,
Sergey
I just tested it with MS Access
Try to use `sign instead of [] for the filed name
The following script is working:
OLEDB CONNECT TO [Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=Z:\data\Test\QlikCommunity\2014.11.18\test.accdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=6;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False];
LOAD ID,
`test$a`,
testB;
SQL SELECT ID,
`test$a`,
testB
FROM Table1;
Hi Sergey,
Please try with test$(a).
regards,
Manoj
Could you just rename the column in Access DB?
Regards,
Sergey
Hi Manoj,
Did you tried this by using the Select button in Edit Script window? Try to generate the query using Select button and check.
OR try this
SQL SELECT ID,
"test$a" AS ColumnName,
testB
FROM Table1;
Hi Jagan,
The problem is not in $-sign but in $(a) at the end. It's interpreting as $-sign expansion
Regards,
Sergey