sshilpam
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: How to avoid Reading Data File Multiple Times
Thank you Ajay for the response. We have a file which has the list of conditions. For one component the conditions could be 5 and for other component the conditions could be 10. Since this is dynamic, we will not be able to tell how many data copies are required. Is there a way we can build this dynamically.2.5KViews0likes0CommentsHow to avoid Reading Data File Multiple Times
Hi, How to read the file only once and perform multiple validations on the file. Example: My file has 20 columns and I want to find the count of 4 different columns (Column1, Column4, Column9 and Column19). I have the logic to get the count built in a child pipeline and the Parent pipeline passes the column names for which the count has to be found. Since the columns can be changing for each file, we have made this dynamic. Issue here is, we are reading the file in teh child pipeline and based on teh column names passed from the parent pipeline, we are getting the count. If we need to get the count for 4 columns, the child pipeline will execute 4 times and the input file is being read 4 times. Is there a way we can avoid reading the file multiple times. Example: I want to find the count in Message, Invoice_id and amount columns.2.9KViews0likes2CommentsReplace values from one file in another file
Hi Team, We are new to snaplogic and have started building pipelines. There are few cases where we are having challenges. I have two csv files. Image 1: The first column has the column names which are present in the file shown in Image 2. Question: I need to search for the Source Value in the file in image 2 and replace with Target value. This replacing should happen only in the Column name mentioned in the first column of file 1 Appreciate your help. Also can you let us know if using Expression language is better or the Snaplogic Snaps for any given task ?2.6KViews0likes3Comments