Friday, February 4, 2022

Two files in SFTP will have different headers in CSV format.

 * There will be 2 files in sftp 1. Create and 2.Update both files will have different header in CSV format.

 * Create file will have 7 header and the update file will have 3 header.

Example :

Create filename - ActivityCFile

Update filename-ActivityUpdateFile

Step:1

In Content Modifier read the sftp file name using ${file:onlyname.noext},


Step:2
 
Use Router condition to check the file name with 'ActivityC' or not- ${property.Filename} contains 'ActivityC' 

* Contains means it will check the file name with 'ActivityC' then it will satisfy the condition.


After the router condition, we can convert csv to xml and proceed based on requirement.








No comments:

Post a Comment

The sender will pass the data in JSON format without converting it to XML format. We need to read the particular field.

The sender will pass the data in JSON format without converting it to XML format. We need to read the particular field to check the conditio...