Hide Prefix

[Anonymous]

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

[wdchristensen]

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]

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

[Digvijay_Singh]

May be this -

SET HidePrefix='%';

X:

Mapping

Load

A,

"%B";

SQL SELECT A,

B as %B

From Loc

[Digvijay_Singh]

Or may be -

May be this -

SET HidePrefix='%';

X:

Mapping

Load

A,

B as "%B"

SQL SELECT A,

B

From Loc

[zebhashmi]

B as [%B]

[Anonymous]

I did this but did not work

[Anonymous]

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

[Anonymous]

It did not work still I am getting general OLEDB error

[Anonymous]

This is the error I am getting.