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

[Anonymous]

Both of the methods did not work

[zebhashmi]

Can you use load instead of select if you want to use select try put every thing in inverted commas like "A"

[ChennaiahNallani]

try this way:

SET HidePrefix='%';

X:

Load

A,

B;

SQL SELECT A,

B

From Loc:

Mapping

load

A,

B as "%B"

Resident X;

[wdchristensen]

The code snippet below should work.

SET HidePrefix='%';

X:

Mapping Load

A,

[%B];

SQL SELECT A,

B as [%B]

From Loc;

If the above code doesn’t work, you might try something simple like:

Load

A;

SQL SELECT *

From Loc;

If that doesn’t work then maybe your connection is not valid or the account you are running the query from doesn’t have access to the View / Table in the database. Or maybe the connection doesn't default to the intended database or schema. This would mean that you would have to fully qualify the source (Database.Schema.Table). If you can connect and can pull data from the query, add one piece at a time until it breaks so you know what exactly is causing the issue. If you can post the last part that worked and the next part that doesn't work, it will make fixing it much easier. Hope that helps...

[pagegreg]

SET HidePrefix='%';

X:

Mapping

Load

A,

B as %B;

SQL SELECT A,

B

From Loc:

[Anonymous]

I tried all above methods in Qliksense none of them works for my script.

[wdchristensen]

Perhaps the reason none of the solutions above fixed your problem is because you have a "General OLE DB error". This could mean you have 2 columns with the same name or something like that. Might want to avoid using "*" so you ensure you are getting what you want. Run the query in SSMS to make sure the query is legit and you have access. Did you full qualify your table names as previously suggested?

[Anonymous]

I am not still able to hide the script though error was corrected.

Will search exclude fieldname help in this case.

[wdchristensen]

Can you supply a business case for what you are doing. Not sure I know what you mean by "Hide". Do you mean alias (give the field a different name) or exclude it from the application? Is it creating a synthetic key or something? Why are you doing the hide activity in the first place?

[Anonymous]

I have two fields in the table which shows same data. My client wants to see only one field.Tried commenting out each of them individually did not work  throwing script error. So was trying to hide did not work. My script is very complicated. Same app works on more than 20 schema so.