We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

XLS find header

wonka1234
10 - Fireball

Hi,

 

XLS file doesnt allow me to import at a certain line.

How can I find the row "SERIES" to start my data there?

 

I want to start it at row 9 in this instance. Is there a way to start at the word series?

 

wonka1234_0-1658776687009.png

 

2 REPLIES 2
gabrielvilella
14 - Magnetar

Hi @wonka1234, you can use this process to identify the word Series and remove anything that is prior that.

gabrielvilella_0-1658777046844.png

 

FreeRangeDingo
ACE Emeritus
ACE Emeritus

Is series always going to be on row 9 or will it vary?

Labels
Top Solution Authors