Excel

Header Column Present

Required

Specify whether Header is present in the sheet. If "No", is selected, the entire range will be treated as data.

Yes, No

Default Value: Yes

Header Row

Required

Row number on which headers are present

Integer Value

Default Value: 1

Data Row

Required

Row number from which data starts

Integer Value

Default Value: 2

Sheet Name

Required

Enter the name of the sheet

String Value

Insert Mode

Required

Specifies the manner in which data will get updated in the data warehouse : UPSERT will insert only new records or records with changes, APPEND will insert all fetched data at the end, and REPLACE will drop the existing table and recreate a fresh one on each run. Recommended to use "Upsert" option unless there is a specific requirement.

Upsert, Append, Replace

Default Value: Replace

Upsert Key

Dependant

Required

(If Upsert is chosen as the Insert Mode Type)

Enter the column name based on which data is to be upserted.

String value

Attempt Schema Inference

Required

If Yes then value types will be fetched as it is, eg: Float will be fetched as float. If No then everything will be fetched as string irrespective of its type.

Yes, No

Default Value: No

Compressed

Required

Choose Yes or No depending on the file compression

Yes, No

Default Value: No

Compression Type

Dependant

Required (If Compressed = Yes)

Specify the file compression type

Zip, Gzip

Footer

Optional

Specify the row number containing the footer, data after this row will not be extracted

Integer value (eg:10)

File Encoding

Required

Specify the encoding type of the file which will be used to decode the file

String value (eg:utf-8)

Include Source File Name

Required

Set this parameter to 'YES' if you want to include source file name in the data warehouse. Default: 'NO'.

Yes, No

Default Value: No