Function to get certain cell from different excel tabs

Hi,

I imported 78 tabs from an excel using the Dynamic Input. All the tabs are formatted similarly but they don't have a header. I wanted to use the function that can take certain cells from each tab and put it in a different excel. Do someone know if that is possible?

Thanks.

Help

Accepted answers

Claje

So you should be able to use the Select Tool in order to only choose Column B as your final output, which would get you cell B4 only, and you can then put this together with other outputs to get your final results.

Another option might be the Transpose tool. You could Use the LineNumber that the workflow creates as a "Key" field, and then use a filter of "LineNumber = 4 AND Name = "Field2", which would get you all "B4" Cells in your files.

All comments

Claje

Hi,

This is definitely something you can accomplish, and Alteryx is a great tool for doing so.

When you say certain cells from each tab, how would you define that? Are they in specific rows and columns, or are they data elements where a certain field has a value you are looking for?

sagarpatel11

For example, each tab has investor info and I want to get some info but not all info from each tab. Like cell B4 has Investor Code and investor code is in same cell in each tab. I want to tell altreyx to go to each tab and grab that investor code and output in a different excel in a column "Investor Code".

Thanks,

Sagar.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703