Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have been using SQL in my load script
I wish to exclude some columns so they don't appear in the smart search
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?
Go to Solution.
Can you try
Search Exclude [*CustomerID];
at the end of your script??
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
DepartmentRepresentative (this is the column name it brought back)
is there a way to stop smart search searching for the word Manager within the columns too?
found a way
Search Exclude [*DepartmentRepresentativer];
just have to make sure I exclude all the columns that contain the word "Manager"
thank you x