Importing .slsx where second sheet continues data

[Ciaran]

Hi guys

New Alteryx user here. Was hesitant to ask this as I have been browsing looking for hep on this issue and see how many issues are similar but really couldn't find a solution.

I have a spreadsheet where the first sheet contains headers and the the rows of data. this sheet comes named output. Then the second sheet has a blank row and then the data continues, this sheet and following sheets are Sheet 1, Sheet 2 etc.

Output

Header 1	Header 2	Header 3
AA	56	fgh
BB	67	vbn
CC	78	dfg

Sheet 1

DD	89	rty
EE	90	uio
FF	01	qwe

I have been trying to use a dynamic input to import them but what is happening is that I get an warning that there are multiple fields named the same and also that there is a different field name than the first in the set.

Alteryx outputs a file that skips that blank row (which I want) but then skips the first row of the data in Sheet 1 and every subsequent sheet.

Appreciate any help.

[AngelosPachis]

Hi Ciaran,

If you can mock up an example of how that file is structured, I think it would make it easier for people to help. 

Thanks,

Angelos

[Ciaran]

Hi Angelos,

Have added an example.

[mathieuf · Accepted solution]

Hi @Ciaran,

Here is a start:

In the dynamic input I have selected the sheet 2 with empty row.