Inbound csv import starting at a specific row

tricial
Giga Contributor

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

17 REPLIES 17

She Sull
Giga Guru

When you initially load the file when creating the import set you can specify the Header row:


Load Data Header Row.png


tricial
Giga Contributor

Yes I have done this


The problem is when it imports the records it is importing only 2 records and skipping with the message Unable to resolve target record, coalesce values not present: u_system_deviceid



The file has 3600+ records and the field referenced does have the correct data


It appears that it is looking at row 1 and not row6


tricial
Giga Contributor

This is a sample of the csv file



find_real_file.png


You get that message when the header row is set to 5? Do you get any additional messages in the import log? I've tried this in the past and it worked fine.