Forum Discussion
Once you get all the files from the ftp location using the Directory Browser Snap, you can use a Mapper Snap in order to map necessary fields produced by the Directory Browser Snap.
My question is: Do you want only to print/store the file names from ftp in one file in SnapLogic? Or do you want for each file on ftp to create separate file in SnapLogic project folder?
Based on the type of the file(csv, json, xml, excel), that you want to store the details, there are designated Snaps for each like: JSON Formatter, CSV Formatter etc.
Regards,
Spiro Taleski
Hi @Spiro_Taleski,
For now, it would suffice to have an excel file where each row will contain the name of the file.
How do I reference the file name in the mapper? Is there a document listing all $fields that can be referenced on a particular snap?
Best,
Izzy Babcock
- Ajay_Chawda5 years agoContributor
Hi Amrita,
it seems like you are trying to join values which are in array format.
Can you share sample screenshot what input you are trying to pass to join. @Amrita You are trying to join two data set by array which can’t be done.
Looks like you have to use json splitter snap to split array of column name and Column name target field at both input views then use mapper(optional) to select the join id along with other data. If you want to sort by id then use sort snap after mapper, if not make sure you choose unsorted option in join snap.
Related Content
- 3 months ago
- 11 months ago
- 3 months ago