Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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??
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
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