Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Importing .slsx where second sheet continues data

Ciaran
6 - Meteoroid

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 1Header 2Header 3
AA56fgh
BB67vbn
CC78dfg

 

Sheet 1

   
DD89rty
EE90uio
FF01qwe

 

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.

3 REPLIES 3
AngelosPachis
16 - Nebula

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
6 - Meteoroid

Hi Angelos,

 

Have added an example.

mathieuf
Alteryx
Alteryx

Hi @Ciaran,

 

Here is a start:

 

mathieuf_0-1639131961025.png

 

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

Labels
Top Solution Authors