Qlik Sense - hide columns from smart search SQL

[joeybird]

Hi

I have been using SQL in my load script

I wish to exclude some columns so they don't appear in the smart search

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Searc...

I don't seem to have much luck with this.. I have tried

CustomerID AS  [*CustomerID],

with no joy. Where am I going wrong please?

[Anonymous · Accepted solution]

Can you try

Search Exclude [*CustomerID];

at the end of your script??

[joeybird]

Hi

this hides the column from the smart search, Great thank you ...but

but does not hide any column with data within

I went on to exclude Manager 

Search Exclude [*Manager*];

but when I completed a smart search for "Manager"

it found a column that contained the word Manager

as

DepartmentRepresentative (this is the column name it brought back)

Joe Bloggs,Wales,Manager

is there a way to stop smart search searching for the word Manager within the columns too?

please help

[joeybird]

Hi

found a way

Search Exclude [*DepartmentRepresentativer];

just have to make sure I exclude all the columns that contain the word "Manager"

thank you x