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 change the name of B in the Loc table to use the special character "%" in the alias (%B) then it will no longer recognize the join between on Location02.B. Loc.[%B] will not recognize Location02. now because now they are different names. If the two tables no longer join as they used to, this will likely result in a error in your load script.

[Anonymous]

Yes I think same thing is happening. what could be the solution for this ?

[wdchristensen]

In table Location02 (and anywhere else B is used for the first time) alias B to the system name B%:

Location02.B as [%B]

Or

Location02.B as "B"

Your application will likely run through the script and because of the line SET HidePrefix='%'; field B will not be shown in the field name lists because you hid the system fields. Is that what you are expecting? 

[dwforest]

Could it be an issue with % as hide prefix as this is sometime a wild card?

The system Help uses _ (underscore), perhaps trying a different character.

And Yes all the other good things pointed out:

The prefix is not ignored for joins, so be sure all fields intended to be joined have the same name (including prefix)

A prefixed alias of the field is not the same, so you can't select "B" from a load of "_B"

[Anonymous]

Yes