Stage File read records based on a filter ?
SummaryWondering if i can read a few records from all records in a file in stage file using a filter
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.