You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Stage File read records based on a filter ?

Received Response
28
Views
1
Comments
edited Jan 20, 2021 4:33PM in Integration 1 comment

Summary

Wondering if i can read a few records from all records in a file in stage file using a filter

Content

Hey There, 

suppose I have a file with 10 columns and 100 rows. I want to download it -->stage it--> write a new file with only 4 columns. 

My question is when i stage the file, is it possible to add a where condition on the source file which says something if cost center column = 90 only get those rows into stage file read action. 

Thanks,

Swap

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!