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

[jagan]

Hi,

Just a try if we do this using Qlikview's Select button may be they would have handled, not sure about this.  Lets see how they handled this. 

Or

We can try creating a view in database and give alias to the column name in view and use this view to access the data in qlikview.

Hope this helps.

Regards,

Jagan.

[#3]

Jagan,

doesn't make a difference whether you write the query yourself or use the select button.

Obviously it is simple to edit the column name in the database but I was just wondering if there was a way to write characters just like &amp in HTML.

thanks,

Manoj

[SergeyMak]

Hi Manoj,

I tried to use chr(36) in different ways, but it doesn't work, unfortunately.

I see only one way - build a view in DB where you can rename this field and use this view as a source.

Regards,

Sergey

[jyothish8807]

Hi Manoj,

I check this and observed that QV ignores the $(a) part.

Eg. if field name id amount$(a) on reload it takes Amount as field name.But i dosent give error.

Regards

KC

[jagan]

Hi,

As I suggested earlier you can create view on top of the table, so that you don't need to alter the table.

Regards,

Jagan.

[anbu1984]

Use Load * From Table;

[#8]

Hi Anbu,

Yes, I guess that is one way but then I would be loading all the other columns that are not needed.

thanks,

Manoj

[#9]

put condition like

where  wldmatch(*$*) ....

[#10]

I did not get your answer. Can you write the script say for a table that has one column TotalSales$(K)?

thanks,

Manoj

[#11]

i am not sure it works

my idea is

load

*

from table

where wildmatch(*$*);