I created a sequence that creates a datatable and filling it with information about random generated people (name, phone number, location, job position and zodiac sign).
After the DataTable is created i would like to output data while filtering them as per zodiac sign.
For that reason i assign a new variable “FilteredData” using DataTable.Select() function.
It works perfectly fine if i use a specified zodiac sign e.g “Leo” as you can see in the photo below:
However i tried to make an extra step and make the user select the zodiac sign he wants to output using and InputDialog activity and storing the user’s selection in a new variable (selectedZodiac).
I can’t assign the users option in the FilteredData variable as i did before in order to output the people with the “selected” zodiac sign
(i have tried a lot of things like
ExtractDataTable.Select(“Zodiac = ‘selectedZodiac’”)) ,
ExtractDataTable.Select(“Zodiac = selectedZodiac”) ,
ExtractDataTable.Select(“Zodiac” +selectedZodiac) ,
ExtractDataTable.Select(“Zodiac” == selectedZodiac) ,
The main problem is that i cant “transfer” the value of the selectedZodiac variable in the FilteredData using the .Select function.
Thank you in advance