SharePoint Input not recognising Column Headers / Filed Names from Excel File

Question

We are switching a lot of inputs over from reading SharePoint 2016 UNC File paths to the SharePoint Files connector.

When doing this Alteryx is not picking up the column headers/field names from the file and it cannot be processed as normal.

We have gone into the connector options and selected the following:

But they are still not being read:

Top header from input file for reference:

Have missed something or is there something bigger afoot???

Cheers

Mark

mceleavey · Answer

Hi @MarkH ,

it looks like you're skipping the titles by changing the import line to line 2.

You need to change this to be the line on which the title row appears. I've replicated this and it's working for me.

With the following config:

I get the following, which shows the raw format of the file:

This is the header row in Record 3.

So with the following config I get the header row as expected:

Change your "Start Data on Line" setting to 1 and this should work for you.

M.