Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Yes I think same thing is happening. what could be the solution for this ?
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?
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"
Yes