Loading Column that has a $ sign

[#1]

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

[#2]

Thanks for the reply but since $ is a system field QlikView ignores it and returns the error "field [TotalSales] not found".

regards,

Manoj

[SergeyMak]

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

[#4]

Hi Sergey,

My bad. The field is "TotalSales$(K)" and it errors out.

thanks,

Manoj

[SergeyMak]

Manoj,

could you show the actual script?

Regards,

Sergey

[SergeyMak]

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;
 

[#7]

Hi Sergey,

Please try with test$(a).

regards,

Manoj

[SergeyMak]

Could you just rename the column in Access DB?

Regards,

Sergey

[jagan]

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;

[SergeyMak]

Hi Jagan,

The problem is not in $-sign but in $(a) at the end. It's interpreting as $-sign expansion

Regards,

Sergey