SpiroTaleski
Valued Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: How to get filename from file reader
omiaye Coupe of options how to get the filename: Directly from the Directory Browser Snap: Put a Copy Snap after the Directory Browser Snap with Mapper on the second branch in order to map the name of the file. Field containing the name of the file should be names as "Name". And then you can join the stream after CSV Parser Snap. Directly from the File Reader Snap: Put a Binary Copy Snap after File Reader Snap with Mapper (input view to be in Binary type) on the second branch in order to map the name of the file. Two fields that you can look up in order to get the file name: content-disposition or content-location. You will need to utilize the SnapLogic functions in order to extract the filename and then you can join the stream after CSV Parser Snap. BR, SpiroRe: Generate expression file from database query
XanderVR Achieving the desired output (without the getValue function) can be done using the reduce function. First you need to group the records by $code, using Group By Fields snap. After that following expression can be used: {[$groupBy.code]:$group.reduce((acc, curr) => acc.extend({[curr.source]: curr.target}), {})} BR, SpiroRe: Renaming multiple items in an array
AvaniAnand If you want to add another mapping rule, you can do that withnin the existing mapKeys function: map(x => x.mapKeys((value, key) => key.contains('Memo') ? "description" : (key.contains('unique_id') ? "custcol_xero_unique_key" : key))) Or, if you need to add conditions for more fields than also you can utilize the match operator.
