how do i do an exact field search in data catalog?

  • 29 April 2024
  • 5 replies
  • 52 views
Prasad Rani
Userlevel 2
Badge +1


how do i do an exact field search?

For Ex: I have a field named trd_settle_date  - and when i search for that in the data catalog, it is Giving me all fields in catalog that either started with “trd” or had “settle” word some where in it etc.,Because of that, the search is giving so many unnecesary values in the list, and making it difficult to find the right one.

How can i get Ataccama to perform exact match to my search string? If it doesnt find - its OK for it to give me “no items found”

5 replies

Albert de Ruiter
Userlevel 4
Badge +4

Hi Prasad,

I'm not sure which version you have (we are still on 13.9), but we encounter the same. We have asked Ataccama about this and they stated that in a future version seach functionality is to be improved. I suppose 15.x.

Kind regards,

Albert

Cansu
Rank
Userlevel 6
Badge +7

Hi @Albert de Ruiter @Prasad Rani please feel free to create a new idea post if you have any specific feedback on the search functionality and the team will for sure consider them in the process 🙋‍♀️

Check out Our Community Recommended Journey to get started on the community 🙋‍♀️
Prasad Rani
Userlevel 2
Badge +1

@Albert de Ruiter : we are on 14.5.1 - and as far as the search, I tried putting the search string in double quotes, single quotes etc., that didnt work. When the string has multiple words  connected through underscore, it should be considered as ONE word and allow me to give exact search results first followed by any other close results. But the exact search is missing here even in 14.5.1 (unless Iam not doing it right)

 

Albert de Ruiter
Userlevel 4
Badge +4

@Prasad Rani , during a session we had with Ataccama product specialists, stressing that the search functionality very negatively impacts user experience, it was confirmed that the presentation of search results is far from ideal. Also it was my understanding that in a future version the fucntionality will be improved. With your experience in 14.5 that should be version 15.x then.

@Cansu is here a way that you can get a confirmation on that please?

Kind regards,

Albert

M
Rank
Badge

Hello @Prasad Rani,

if you want to search strictly by exact match, then I would recommend using AQL-based search. You can find the documentation here.

E.g. if you want to search for a catalog item with the name being exactly “loan_customer_corporate”, you can do it by going to the listing of Catalog Items, then switching to the tab “All” and in the search bar switching to “AQL Search”, so you see the curly braces on the left side of the search bar and then typing:

name = "loan_customer_corporate"

I hope this will help to solve your problem, if not, please feel free to ask any follow-up questions.

Reply


Community Terms of Use & ConditionsCookie settings