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

Alteryx designer Discussions

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

Is there a way to get data from a specific file from multiple tabs of excel?

Highlighted
Asteroid

Hey,

I was looking for a way to make a standard workflow to get data from various specific cells from multiple tabs of an excel file.

I wanted to make a table with specific fields and specific rows from 2 tabs of excel. 

I want Column B and C from Sheet 1 with the rows- 2,3,4,7,8 

Data in Column is always standard, however, the data in column C changes.

And I also want to use the "Name" and "Analysis Date" (Sheet 2) to get populated in another line

Furthermore, is there a way to get the output in a text file?

Please find the attached screenshots.Details.JPG1Firm.JPG2

 

 

 

If I understood your question correctly, you should be doing something like this:

 

 

img.PNG

 Output:

Img2.PNG

 

 

 

 

 

 

 

Labels