cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

SnapGPT Example: CSV Filter and Write

arodriguez
Employee
Employee

I used the following to prompt to successfully generate a pipeline that reads data from a csv file, filtered the data and wrote the data to a new file.

Read a csv file, then map Registered, Last Name, Email and % complete, then filter records where Registered is equal to or greater than 2023-05-15, and % complete is equal to or less than 40, then write records to csv file

4ab928d045ac997a0c8cb3e973c7f01a6bd4d723.png

Resulting pipeline:
504c72771073ae58a4303cd15b7f973ae20557fa.png

I did need to modify the Mapper Snap and provide a file name but the filter expression was a success.

8dd11f0340ccfa8585fa5a71085e909f2a4e4004.png

c3f342a438962f33734559fcaddbfd5bea90fe4c.png

2 REPLIES 2

Jeremiah
Employee
Employee

This is an interesting use case where the goal was a data processing action without system integration on input or output. Are you planning to update the pipeline with a connection to the origin system @arodriguez?

Yes, my intention is to use the origin system API endpoints.