CSV To Database Mapping
  • 14 Dec 2022
  • 1 Minute to read
  • Dark
    Light

CSV To Database Mapping

  • Dark
    Light

Article summary

Step Details

Introduced in Version5.0.0
Last Modified in Version5.0.0
LocationData > Excel & CSV

The CSV to Database Mapping step will directly map the CSV to the database when the input file contains the same field names matched with existing fields selected in the database type.


Properties

Data

PropertyDescriptionData Type
Database TypeAllows the user to define the database structure to map---

Inputs

PropertyDescriptionData Type
File InputThe CSV or excel file that is used as input.
FileData

Input Data

PropertyDescriptionData Type
Input File TypeDefines the type of file used as an input to the step. Currently, the options are Csv, Excel_xls, Excel_xlsx and AutoSelect
---
Worksheet IndexDetermines which worksheet that will be evaluated.
Int32
Ignore First LineIgnores the first line of the worksheet often used as headers in Excel files.Boolean
Ignore Empty RowsIgnores any rows that don't contain any data.
Boolean
CSV DelimiterDetermines which delimiter will be added with the values for CSV files.
---


Related Information

Forum Posts:
Get Database Structure Data As CSV File


Was this article helpful?

What's Next