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
Join the data of multiple sheets in an excel
Hi Team, I have a excel file from the source where it has one lakh number of records. And that excel file has multiple sheets of data and is related with each other from a primary key. I need to join the data of multiple sheets to have the related information of one entity. Since the records count is more it is difficult to have join snap as it consumes time. I have tried sorting and grouping and then fetching the info from other sheets. Still I need more feasible solution with less time consumption. Regards, Mohammed SuhailWriting 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, Harshavardhana
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.
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?EXCEL Formatter: Is it possible to write formulas to cells?
We are trying to write formula strings as values to Excel cells, but when the file is opened all that appears are the formula strings and not the evaluated values. We have tried prepending an ‘=’ to the strings but that just results in the string with an ‘=’ char prepended. Hitting ‘F2’ in a cell will immediately evaluate the cell, but that is not workable for end users. If we modify the cell in-place with the ‘=’ character then the formula evaluates. Any help/guidance is appreciated. Thanks, TK
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.
