Inbound csv import starting at a specific row

[tricial]

I have an inbound action that is creating a data source from a csv

On import I have the inbound action set to current.header_row = 5

I would expect the import to start from row 5 as header and then import the data from row 6 onward, however it keeps failing and is trying to still import the data in the csv file from row 1

My csv file has 4 title rows and the header row is actually on row 5

I need to ignore the files title rows and start the import from header row 5 and then the data is in rows 6-### (can be any number of rows that follow the header

This file comes from an automated system

The first 4 rows have report information

The actual data that I need to transform starts at row 5 (header row)

Any ideas how I can achieve this?

Thank you

[Gowrisankar Sat]

hI patricia,

Can you check if the import set table has all the columns in the excel created as fields?

[tricial]

Hi, Yes the import set table has the fields that are in the csv file

The data in the file is a number and the field is set as a string

I am using coalece also on this field

[Abdul Fathah]

Hi,

Did you fixed this issue?