Jump to content

How to filter data in DataMan using a variable


Recommended Posts

Hi @Griz2

if the variable is an integer, you can insert the @Var_name in the filter as in the image below 

If the variable is nominal or if you want to filter with a string in particular the step to follow are the following:

  1. Create a new variable Var_1
  2. Assign to it the function Var_1=ifelse(find($"NameOfTheVariableWhereYouWantToAplyTheFilter",@Var_name),1,0)
  3. Filter Var_1 (equal to 1 in case you want to keep all the record with your variable value)
  4. Delete Var_1 

Let me know if any passage is not clear to you.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...