Forum Discussion

MallikarjunNuli's avatar
MallikarjunNuli
New Contributor
8 years ago

How to read Multiple Sheets from an excel dynamically using Snaplogic

Hi , I have requirement to read a single sheet at a time and load the data in to a table from the same excel file which contains more than 40+ of sheets. Is it possible to do this through Snaplogic...
tstack's avatar
tstack
Former Employee
8 years ago
Copy LinkReport

What are the file formats (e.g. CSV, JSON, XML, …)?

Do you need to do any transformations to the values before insertion?

The DB Insert snaps (e.g. MySQL Insert) have an option to create the table if it is not present. I think the table creation is done based on the values in the first record to be, so string properties will be VARCHAR columns in the DB, numbers will be a number column, and so on. Is that sufficient or are you looking for more?

  • krupalibshah's avatar
    krupalibshah
    Contributor
    9 years ago
    Copy LinkReport

    Yeah, but still got the same error.
    It got solved, not sure how.

    But now when I am trying to use the same insert query in different ways I get this error,

    Content of Json generator:

    [
    {

        "ACTIONNAME": "Audit",
    "TRANSACTIONID": "536b983a-bb79-4a0f-afa7-6c3b4a8890b9",
    "ENTRYTIMESTAMP": "2017-08-10T08:37:22.882",
    "EXITTIMESTAMP": "2017-08-10T08:37:22.882",
    "SOURCESYSTEMNAME": "_sSName",
    "TARGETSYSTEMNAME": "_tSName",
    "PIPELINEPROJECT": "PipelineProject",
    "PARENTPIPELINENAME": "_parentPipelineName",
    "CHILDPIPELINENAME": "_childPipelineName",
    "ASSOCIATEDPIPELINE": "_associatedPipeLines",
    "USERNAME": "_userId",
    "SNAPLEXNAME": "SnaplexName",
    "PARENTPIPELINEINSTANCEID": "_parentPipelineInstanceID",
    "CHILDPIPELINEINSTANCEID": "_childPipelineInstanceId",
    "BATCHID": "_batchID",
    "BUSINESSID": "_businessID",
    "STATUS": "_status"
}

    ]

    Output of Mapper1 where we are getting error

    Output of Mapper2 where it runs fine