Forum Discussion

kpatnala's avatar
kpatnala
New Contributor
7 years ago

Storing each document into database table.. [xmlformatter --> generic jdbc insert]

Hi, i’m getting following error when executing “Generic Jdbc insert” snap. i have 2 data values that need to be inserted in 2 column table. mapper gives me col1, col2 each having list of 3 valu...
Aleksandar_A's avatar
Aleksandar_A
Contributor III
4 years ago
Copy LinkReport

Hi @darshthakkar,

Try using Pipeline Execute Snap, so you can write one file per one input document. Also you can pass snap.in.TotalCount as Parameter so you can name the files as you listed before.
Below is the Pipeline Execute Snap Settings:

The Child Pipeline that is used for writing the files should look like this:

And the File Writer Snap Settings:

Note * This is only for csv files, there is not a html formatter in the available Snaps. *
For dynamic formatting a html file head over to https://community.snaplogic.com/t/how-to-generate-a-html-file-with-snaplogic/1186

BR,
Aleksandar

    • Supratim's avatar
      Supratim
      Contributor III
      6 years ago
      Copy LinkReport

      @pranil2k2

      Go to Oracle Marge view and add output view. After that use aggregate snap for count.

    • SpiroTaleski's avatar
      SpiroTaleski
      Valued Contributor
      6 years ago
      Copy LinkReport

      Hi @pranil2k2

      You can try by opening the error view for Oracle Merge Snap(meaning that all the error rows will be routed in that view). In that way you will isolate the pipeline from failing.

      As an output of the Oracle Merge Snap you will get all successful records.

      To count the records from output you can use :

      1. snap.out.totalCount - you will get total number of documents that have passed through.
      2. Use Aggregate Snap(function Count) on some unique column(field).

      Regards,
      Spiro