Excel Formatter - need date datatype with this format MM/DD/YYYY
Im using Excel Formatter. I am selecting from Oracle. I need the column in excel to be date datatype, but have this format MM/DD/YYYY with no time on the end. I can get the date into that format if I do a to_char(mydate, ‘MM/DD/YYYY’) in the select, but the datatype is always General no matter if I click the “Translate Date and Time Types”. If I let it be a date in the select as it is naturally from the table datatype or I do a to_date(to_char(mydate, ‘MM/DD/YYYY’), ‘MM/DD/YYYY’), no matter what the checkbox is set to its always General and it puts the time on the end? I cant win. When I export from Oracle SQL developer to excel, that tool gives date datatype with this format MM/DD/YYYY no problem.
Table Creation in SQL server with specific data type using data from excel file
Hi all, Thanks in advance for read and any help here. I have a pipeline where I had a excel file, with columns name and table name, so first I read this excel file and them make a parse, this is a sample of the excel file: So I want (if not exist) create a table AAA with the columns 0XX5, 0XX6, 0XX7, 0XX8, 0XX9 each one with the respective Datatype, how can I o that?
Can Excel Formatter Insert Data at an Offset (Column or Row)?
I have a requirement, that I insert data into a series of sheets in an Excel workbook - and the sheets are not blank. Is there a way to tell the Excel formatters (would love to use the multi-sheet formatter for this) to start inserting at a particular row, or better yet, a cell? I see some folks have asked for something similar, Anyone aware on how to insert the data into excel file from a specific line number (in excel sheet)? - Designing Pipelines - SnapLogic Community If this is not possible, I am new, and I wonder: What is the best way to request this feature? It seems to come up periodically in various forms.
Writing multiple data in a single excel file sheet
Hi, Good day, I have got a requirement to append the data in an excel as the incoming data is coming from various sources. Since the append operation is not allowed, I would like to know if is there any way of loading the data in different sheet names in the same excel file.? Thanks, HarshavardhanaRefresh Excel Pivot Table
The attached sample excel has three sheets: Sheet “data” - This sheet has the raw dump of data Sheet “pivot” - This sheet has a pivot build out of the “data” sheet Sheet “stats” - This sheet builds a summary data using the “pivot” sheet The goal is to refresh the pivot table in the “pivot” sheet once new data is added in the “data” sheet. Any help would be greatly appreciated. sample_pivot.xlsx (15.4 KB)Excel Merger
Hi, Whether is there any way to merge two Excel data into one using the Snaplogic? Like A,B, C and D,E, F are headers belonging to two different excel Ex1 and Ex2. And I require a combined Excel concatenated side-ways like A,B, C,D, E,F Screenshots below: Ex1: (Excel 1) Ex2: (Excel 2) Expected Output: Thanks, Harshavardhana