Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to filter th...
 
Notifications
Clear all

I need to filter the specific data that is required in the data frame. How do I filter data in a workflow?

1 Posts
1 Users
0 Likes
228 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: Once the data has been imported, click on data preparation. (Refer to the image below).  

1671709718-datapreparation.png
Step 2: Drag and drop the filter node onto the main screen. Connect the two nodes. (Refer to the image below). 
1671709818-filter.png
Step 3: Once a successful connection is made between ‘data import and filter’, click on the filter button available on the right panel. Filter pop-up appears. (Refer to the image below).  
1671709850-filter1.png
Step 4: Click on the dropdown under column. The dropdown shows the columns that are present in the table. Select the column that needs to be filtered. (Refer to the image below). 
1671709928-filter2.png
Step 5: Click on filter condition. A dropdown appears with filter options. Click on the operator to filter the columns. (Refer to the image below).  
1671710020-filter3.png
Step 6: The Filter value needs to be entered manually under ‘Input’. Click on ‘Apply’. (Refer to the image below).  
1671710060-filter4.png

Step 7: The user can click on the plus button under ‘Action’. Select logic. 

Step 8: Follow the same procedure as above. The user is also able to delete the same. (Refer to the image below). 

1671710091-filter5.png

Step 9: Once filter is configured, click on the run button or the filter node twice to run the workflow. 

Step 10: Click on the icon in the bottom line. (Refer to the image below).  

1671710129-result.png
Step 11: The filtered data is reflected in the form of a table. (Refer to the images below).
1671710174-filter6.png
1671710271-filter7.png
Note: The user can run the workflow for individual nodes as well.

   
Quote
Share: