Hi everyone,
I’m Darshan Hiranandani, new to this and have been working on configuring a CSV file within the “CSV File Input” process in a .psw file. I’ve set up the file, but now I need to validate specific columns and extract data based on certain criteria.
For example, I want to filter out employees who have the role of “Software Engineer” from a column named “roles.” I’m looking for guidance on whether there’s a query-like syntax or method to accomplish this.
Could anyone provide advice or examples on:
- How to validate and extract data from a column in a CSV file?
- Any specific syntax or tools that can be used within the “CSV File Input” process for querying data?
- Best practices for filtering and validating data in columns of a CSV file in this context?
I appreciate any help or suggestions you can offer!
Regards
Darshan Hiranandani
