Preview not available for Flow snaps
Certain flow snaps like “Filter”, “Head”, “Tail” when used in a complex pipeline doesn’t generate a preview while validating the entire pipeline however these generate a preview if the pipeline is simple. For instance, if I’m trying to read data from an excel file with 100k+ records and use either ‘filter’ or ‘head/tail’, I can see the preview when the pipeline has been validated but it doesn’t generate one when the pipeline is huge. Any specific reason behind this? I would want to see the preview as the pipeline that I’m currently developing is a complex one (multiple snaps prior to “flow” snaps), thereafter it needs a ‘filter + head/tail’ (i.e. flow snaps) and then it will again require a bunch of other snaps after those ‘filter + head/tail’ making it complex again. Help on this matter would be highly appreciated. Regards, DarshSolved31KViews0likes13Comments
Search in Array
hi there, I have data coming in these structures source1 - { "@type": "array", "order-line": [ { "line-num": "00010", "attachments": { "@type": "array", "attachment": { "type": "AttachmentText", "text": "Testing the Long Text Documents" } } }, { "line-num": "00020", "attachments": { "@type": "array", "attachment": [ { "type": "AttachmentText", "text": "This is the Third time being sent.\n\nIn our continuing efforts to reduce transportation costs and increaseefficiency Clearway Energy Inc. has contracted Malark Logistics andjointly developed the following routing instructions. Please complywith the following instructions. Failure to comply will result inescalating non-compliance fees beginning at $50.00 per shipment andreaching $250 plus freight costs for subsequent violations.\n" }, { "type": "AttachmentText", "text": "This is the second time being sent.\n\nIn our continuing efforts to reduce transportation costs and increaseefficiency Clearway Energy Inc. has contracted Malark Logistics andjointly developed the following routing instructions. Please complywith the following instructions. Failure to comply will result inescalating non-compliance fees beginning at $50.00 per shipment andreaching $250 plus freight costs for subsequent violations.\n" } ] } } ] } and source2 - { "line-num": "00020", "attachments": [ { "type": "AttachmentText", "text": "This is the second time being sent.\n\nIn our continuing efforts to reduce transportation costs and increaseefficiency Clearway Energy Inc. has contracted Malark Logistics andjointly developed the following routing instructions. Please complywith the following instructions. Failure to comply will result inescalating non-compliance fees beginning at $50.00 per shipment andreaching $250 plus freight costs for subsequent violations.\n", "Id": null } ] } how can I compare to see Source2 Atttachment.Text exists in Attachment.Text of Source1’s , where line-num is same? Any help is greatly appreciated. Thanks ManoharSolved28KViews0likes8CommentsUsing Date.now() while exporting files
Hi Team, While writing files via sftp, I’m unable to ingest Date.now() in the filename itself as seen in the snaps below: (1) Successful execution [passing pipeline parameter and selecting the ‘=’ decorator (2) Failed execution [NEITHER passing any parameter NOR selecting ‘=’ decorator] The reason behind not selecting = decorator is - “I’m not passing any parameter to dynamically generate filename” If the file name needs to be constant and it needs to be exported via sftp with Date.now(), what tweaks should I do? I’m pretty sure, snapLogic would be able to handle that and I might be doing something wrong here. Thanks in advance for your help 🙂 Regards, DTSolved16KViews0likes21Comments
Can We create a Variable in Mapper
Hello Everyone, I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary. I can do it by using variable, have done it using Different tool but never implemented it in snaplogic Hence the question can we create Variable in mapper? any help is appreciated16KViews1like21CommentsHow to remove blank rows from an input flat file?
Hi Team, How can I remove all the blank rows from an input flat file? I cannot use a condition restricted on a single column as the other records are needed. All I want to do is filter out ALL ROWS that doesn’t have any data (like Row 4, 5, 7, 8 shown in the screenshot below) Desired Output: Thus, final output should be: Thanking in advance. Regards, DTSolved15KViews0likes18CommentsCan we hyperlink inside a mapper snap?
Hi Team, I was tryin to use native JS function link in order to hyperlink inside a mapper. I found that it doesn’t work, does anyone know a similar functionality or a workaround? Basically, I was trying to hyperlink an existing column “ID” and wanted to output this in an excel file. Snaps below for reference: Thanking in advance for your help 🙂 Regards, DTSolved13KViews0likes19Comments
Connect SFTP server to fetch multiple files
Hi All, I am trying to connect SFTP server and fetch multiple files from the source remote directory. File Reader snap has an option to get SFTP account but doesn’t find how to provide remote directory path. In the remote directory, we are getting different types of files like *.txt where I need to apply filters based on the filenames to differentiate and invoke the different process to load into SQL DB. Once I fetch the files from remote location how to delete the files. Appreciate your inputs and any relevant links to look into more details. Let me know if you need any further details. Thanks in advance, Amar13KViews0likes16Comments
Join 2 arrays
I have 2 different arrays, one having id, header and another having id,name. Need to join these 2 arrays and get an output file of id,header,name. I need json splitter json path, I have just for id which is jsonPath($, “id[*]”). How do I include both id and header. File.txt (4.2 KB)Solved13KViews1like15CommentsRemoving curly brackets after using "to.String()" across a group of fields
to.String() works as expected for a single field however for multiple fields together, I’m getting an additional { } as seen in the snaps below, would you be able to help me get rid of this? (1) Single Field without using to.String() (2) Single field with to.String() (3) Multiple fields in group without to.String() (4) Single field from a group with to.String() (5) Multiple fields in group with to.String() [The extra curly brackets are in this snap which needs to be removed] Should I go ahead with the route of using another mapper after this and replacing ‘{’ with “”? Thanking in advance for your time and help 🙂 Regards, DarshSolved13KViews0likes5Comments
Can We create a Variable in Mapper
Hello Everyone, I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary. I can do it by using variable, have done it using Different tool but never implemented it in snaplogic Hence the question can we create Variable in mapper? any help is appreciated
Connect SFTP server to fetch multiple files
Hi All, I am trying to connect SFTP server and fetch multiple files from the source remote directory. File Reader snap has an option to get SFTP account but doesn’t find how to provide remote directory path. In the remote directory, we are getting different types of files like *.txt where I need to apply filters based on the filenames to differentiate and invoke the different process to load into SQL DB. Once I fetch the files from remote location how to delete the files. Appreciate your inputs and any relevant links to look into more details. Let me know if you need any further details. Thanks in advance, Amar
