nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Input Same Tab From Multiple Files

JeremyN

I'd like to input the same tab from multiple files. Seems like I should be able to use the directory tool with full path, add a tab name, then send to the dynamic input too, but I can't seem to figure out the format for specifying the tab name. Has anyone done this?

Accepted answers

AbhilashR

Hi @JeremyN, could you give the attached solution a try to bring in all files into Alteryx? The Directory tool reads the file path, which gets passed to first macro that fetches individual excel tab names, which in-turn is passed through the second macro to read-in the data. This approach works any time your data structure changes from file-to-file.

excelReader.yxzp

All comments

T_Willins

Hi @JeremyN,

If the sheets are all in the same format, it can be done with a single input tool. Change part of the filepath to a wildcard while leaving the Table or Query name to the correct sheet. You can turn on Output File Name as a field if you need to differentiate between the files.

Imput multiple files same sheet.png

JeremyN

Thanks! Actually looks like one field is getting pulled in as a different data type, so unfortunately that won't work in this situation.

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15906

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703