Load CSV file with specific header row number

[Ahmmed Ali]

Hello All,

I want to load CSV file data with specifying row number for header row. while loading the same with "load data" module, he data is loading as expected. here i gave row number as 5 as my Header is present at row 5 only.

but if i manually attach similar CSV file to the data source and click on "load all data" in data source related links, it is reading the data from row 1 even though i have saved header row as 5 for the data source.

please help me to solve this.

Thanks,

Ali

[Ankur Bawiskar]

Hi Ali,

Any specific requirement that the csv header will start at row 5 and not at row 1.

Regards

Ankur

[Ahmmed Ali · Accepted solution]

Hello Ankur,

I still did not get solution for the issue.

However i got one workaround for the requirement.

In inbound action, i am reading the entire CSV file data as a string and loading the same into snow table with string manipulation.

Thanks,

Ali