ContributionsMost RecentMost LikesSolutionsRe: How to get filename from file reader omiaye - The output of the directory browser does have the file name, screenshot below for references: If you're using a file reader and have multiple files, use snaps like copy/router/binary router (depending on your use case) and use the field "content-location" to get the desired file. Below screenshot for references again. If you're stuck and need help, please don't hesitate to reach out. Thanks. Regards, Darsh Re: Basic string transformations not working Some of the observations here: 1. Data coming from upstream systems was messed up 2. There were added spaces in the data from the upstream systems itself 3. Ideally, with snapLogic, it should have been able to trim the spaces and help with the transformations however it wasn't able to do so 4. Having said that, the mapper and conditional snap works just right for other set of data so giving the benefit of doubt to the messy data coming from upstream systems. Some recommendations/suggestions: 1. If you're using a csv file, please ensure the encoding is supported in snapLogic and select the encoding accordingly 2. For excel files, it should work just right 3. For data coming from upstream systems like Oracle, Salesforce or Snowflake, try to export the data and see if there are any discrepancies, if there are, align with your team internally to fix it before connecting it with snapLogic. Closing this thread now. Re: Can we generate XML file in pretty print format using native snapLogic snaps? This was achieved by using a custom python script. Re: Is there a way I can delete a folder and all files and subfolders from a windows server? wpenfold - I would rely on Powershell as there is a lot of possibility there. You still would have to define your ps1 files but that should be fairly straightforward considering you have unique identifiers like employee_Id, employee_code, etc. While defining your .ps1 file, you can include code that lists all the files and asks for confirmation before performing delete operation. I would urge you to test in a TestFolder and then scale it up. Thanks. Best Regards, Darsh Re: Join Snap Left Path reading from right input view. vgautam64 - Please share your sample data and pipeline so that I can look into it. I can say for sure that there is nothing wrong with the Join snap, we might be overlooking something in the pipeline itself. Thanks. Best Regards. Darsh Re: Can we generate XML file in pretty print format using native snapLogic snaps? Just to add here, I've tried with uploading XSD and writing a python script too but the results are not intended. Thank you. Best Regards, Darsh Can we generate XML file in pretty print format using native snapLogic snaps? Hi Team, I was curious to know if anybody has worked on a use case where they are generating an XML file in pretty print format? We do have "pretty-print" option in JSON formatter however the same is not available in XML formatter snap. Any suggestions? Thanking in advance. Best Regards, Darsh SolvedRe: ELT Load Snap Failure Hi arvindnsn, Can you please try using double quotes on schema and table name? e.g. "schema_name" (for schema field) and "schema_name"."table_name" (for table field)? I would also suggest you to use Snowflake Bulk Load snap as an alternative. Thank you. Regards, Darsh Re: Fetch dashboard/monitor details via a pipeline Thank you LeeDuffy and koryknick for your inputs. I was able to fetch the required details using the URL --> https://elastic.snaplogic.com/api/1/rest/public/runtime/ Re: Deleting multiple files at once from SFTP folder arvindnsn - I tried with a sample pipeline that generates 6 files over the SLDB and the performance is pretty good. It took ~1.5 mins for completion. I didn't connect to SFTP but just to add complexity on the same lines, I added an email snap that sent me a copy of those files, screenshots below: I have used the innate FileDelete snap for deleting multiple files at once (which does process files one by one) I do agree that if you're having a huge volume, this process would have to run over the weekend. Please lemme know your volume and frequency of this run to understand the issue in detail and whether we can scale up the solution. Thanks. Best Regards, Darsh