Let’s say I have a list of employees, each with a different department in a dataset:
{Abby,IT};{Bart,IT};{Carol,HR};{Dave,IT};{Edward,HR};{Frank,Sales}...
Is it possible when using the “Dataset Column” type to only select employees from a certain department? (limiting to HR would only ever select Carol or Edward)
Or perhaps is it possible to remove rows afterward, that matched certain values?
You could approach this several different ways. Here is what I did:
I created a dataset:
Then in my schema I added a formula field to retrieve all records with department equaling HR.
Thanks for the response.
I forgot to clarify though I don’t want to pull duplicate rows from my dataset. When you use from_dataset it pulls the value randomly. Whereas when i use the “Dataset Column” type I can set it to be sequential to avoid duplicates.
