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?
Can you try
Search Exclude [*CustomerID];
at the end of your script??
View solution in original post
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