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 need to change the file location for about 100 files. Is there a faster way to change the smb location other than giong into the file writer snaps for all 100?
I have a spreadsheet to reformat in snaplogic. The rows contain either employee info or their dependent’s info. The employee row has an address but the dependent’s address fields are blank. I need to populate the dependent address columns with the ma...
Continuing the discussion from Csv file with varying number of columns in each row:
Here is what the file looked like when i started:
EEID|55555|xxxxxxxxx|MICHAEL|C|xxxxx|M|06/21/xxxx
OFFR|55555|01/01/2023-55|OE|01/01/2023|01/01/2023|01/01/2023|12/31...
I have to do this a lot. The sql must have a way to match up on all of these. For example, one sql pulls the employee address. The dependent tables do not have an address on them so i have to put the employee's address on the dependent address rows m...
one issue that remains is that the name of the zip file changes every time. It will have the date and time different each time. Is there a way i could set up a trigger to look at a file with a date greater than or = to doday? How would i look at the ...
i will still have to go in to every file writer snap. is there a way to use a pipeline parameter to look for company id and the current quarter in order to name the files?