This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to use a Zip Writer snap zip a .txt file to become .zip file.
So if my txt file location is /intshare/test/watermarkout//test.txt, when I zip it, the folder structure comes with the zip.
Here is my snap
and when I unzip it, it has folder...
I’m tasked to build a pipeline for API service. This pipeline will accept API calls for GET/PUT/POST/DELETE to a database table.
I am lost at how to get started. Please show me your example.
Thank you
I am using Mapper snap to map an integer column from database to CSV file. How do you write expression for this field “MyNum” to keep the leading zero in the csv file? like 04567
Thanks
My pipeline is a simple pipeline that execute an Oracle query then parse the data to a CSV file. The result of the query gives some of the duplicate records (Same ID), that because the database has those duplicates. However, I just want to keep only...
I plan to use Deduplicate snap to remove duplicate records from a CSV file. In my CSV file, let’s say I have 3 records with the same ID. I just want to keep 1 record.
So I am using Deduplicate snap and set it up like this
It works but it also remove...
@j.angelevski So I did tried this and it looks like it zipped all the files together in 1 zip file.
Is there a way to have each input file its own zip file?
For example, my input are test1.txt and test2.txt. I like to be able to produce 2 zip files....
Hi @marija.nikolovska
Thank you for your help. I actually was looking for way to create my own API. My mistake was not explaining more detail from beginning.
Let’s say I have a database (SQL or Oracle) with a table that has Customer data. I want to u...
I am coming back here to share my simple solution how to write an empty CSV file when there is no data in the stream source (SQL or Oracle)
First, you need to do a COUNT query from your database. Then add a router, if COUNT is not equal zero, then do...