Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

loveqliksense
New Contributor III

Hide Prefix

Hi All,

I wrote the below code in the script

SET HidePrefix='%';

X:

Mapping

Load

A,

B;

SQL SELECT A,

B as %B

From Loc:

I am getting connector error while debugging. I want to hide Column B from the script in Qliksense. How can I do it?

Thanks

in advance

24 Replies
wdchristensen
Valued Contributor

Re: Hide Prefix

If you don't want to import B into qlik you can exclude it from the SQL query and then remove it from the Load section:

Load

A;

SQL SELECT A

From Loc

wdchristensen
Valued Contributor

Re: Hide Prefix

sql.PNG

Also the % is a special character that will need to be wrapped in quotes for your alias.

Digvijay_Singh
Honored Contributor III

Re: Hide Prefix

May be this -

SET HidePrefix='%';

X:

Mapping

Load

A,

"%B";

SQL SELECT A,

B as %B

From Loc

Digvijay_Singh
Honored Contributor III

Re: Hide Prefix

Or may be -

May be this -

SET HidePrefix='%';

X:

Mapping

Load

A,

B as "%B"

SQL SELECT A,

B

From Loc

zebhashmi
Valued Contributor

Re: Hide Prefix

B as [%B]

loveqliksense
New Contributor III

Re: Hide Prefix

I did this but did not work

loveqliksense
New Contributor III

Re: Hide Prefix

I need B on some other place just want to hide it.

loveqliksense
New Contributor III

Re: Hide Prefix

It did not work still I am getting general OLEDB error

loveqliksense
New Contributor III

Re: Hide Prefix

This is the error I am getting.error.PNG

Community Browser