Forum Discussion
Sorry for my wrong input structure. the below is the correct one. It is a list of objects rather than 3 single objects
{‘items’:[
{
‘ID’:123,
‘Name’:‘Tony’,
‘Age’:24
},
{
‘ID’:124,
‘Name’:‘Sam’,
‘Age’:36
},
{
‘ID’:125,
‘Name’:‘Glenn’,
‘Age’:58
}]}
and the view in mapper is like below:
Can you please process now?
Since you’re manipulating an array, you’ll want to look into the “Mapping Root” feature of the Mapper. By pointing the Mapping Root at your array, the Transformations will be applied to the elements of the array instead of the top-level document. Otherwise, the Mapper configuration is the same as suggested by @christwr:
Hi Anil,
The input is from a filter snap with the above mentioned filter expression. This returns 2 files, for example one with 07/02/2019 date and another with 07/23/2019. The expected result from this filter snap here should be the file with the time stamp 07/23/2019 as that is the file with latest timestamp.
Essentially, i am reading a directory folder where excel data files are added every month, and i am wanting to build a pipeline to read the latest file and drop the data after some manipulations onto the database.
Regards,
SantoshHi @Sgarim4
Please find the attached pipeline. which might help you.
pickLastDateValue_2019_07_24.slp (7.1 KB)
Regards,
Anil
Related Content
- 4 months ago
- 2 years ago