community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Input multiple sections of same worksheet in excel

Meteor

I have one excel file that has multiple sections of data.  I need to only bring in certain parts of each section.  in the picture (i have also attached excel file), I only want the green sections.  how would I go about this?

 

Thank you!

MultipleXLSections.PNG

 

 

Bolide

Hi @aberry0613

 

You can check if the second column [end] is null or not.  If it is null, then filter the data out.

 

filter.png

Meteor

Its always something so easy when i think it is going to be complicated.  :-)

Thank you @adm510 !

Meteor

OK, so what about this.  I need the software now listed as a column for each entry.  I have color coded the Visio tab to match what I need the out put to look like (sheet 1).  Basically, I need to take the software title and make it a column for all entries under it until the next section of data.  

 

Thanks

Alteryx
Alteryx

It looks like each time the software is listed on that row for the Machine column the cell starts with Launches.

 

I used that to my advantage within a multi-row formula.

 

Please see the attached, hopefully that gets what you need, you can then add the filter after, as above.

Highlighted
Meteor

Thank you!  I love learning about new tools.

Labels