gg433
New Contributor III
Joined 7 years ago
User Profile
User Widgets
Contributions
Fixed Width Formatter always adds one blank line
I’m using the Fixed Width Formatter snap to create a .txt file with one line in it, but it always writes the file with one extra blank line at the end. I tried adding the Head snap using 0 offset, 1 number of documents and tried 1 offset, 1 number of documents. Still didn’t work. Does anyone know how to prevent the one extra blank line?Insert 2 rows at the top of a csv file
I’m querying a database that’s returning 2 columns, id and color. My requirement is to save this data to a csv file. The first 2 rows of the csv file must have these values, row1 “&CID=555573”, row2 “&SUBID=266690”. The data should have no header row. This is what the csv file should end up looking like if I brought back 2 records. How do I accomplish the hard-coded header rows 1 and 2? The csv formatter doesn’t seem to have the configs I need, I looked into the Document to Binary snap, but cannot figure it out.3.9KViews0likes3CommentsRedshift and SnapLogic
We are trying to stand up a new Redshift environment and want to be able to connect and run pipelines with SnapLogic. Corporate security rules require us to launch the Redshift cluster in a private subnet, no NAT or Internet Gateway, all access through firewall rules. Do we absolutely have to use a Groundplex, can we do it in a cloudplex? If we have to use a Groundplex, can we use an existing Groundplex already running in our SnapLogic account? Thanks!3.3KViews0likes3Comments