Mehrere Excel Files importieren und verknüpfen

Guten Tag,

ich habe die Situation, dass ich mehrere Excel Files (26 Stk) importieren und mit einander verknüpfen möchte. Ich habe es schon über Wild Card probiert, allerdings werden viele Excel Files übersprungen, weil das Schema und die Länge nicht einheitlich wäre (Warnungen), was aber nicht sein kann, da alle Excel Files einen generischen Aufbau haben.

Die Files 26x über einem Import Knoten und anschließend zusammenführen mit einem Joiner klappt auch nicht so ganz.

Falls jemand einen Lösungsvorschlag hat, wäre ich dem sehr dankbar!

Vielen Dank im Vorraus,

Gökhan

Datasets

Output

Accepted answers

Gökhan

Thanks, but I'm relatively new to alteryx and there are several packages in your attache, which one exactly contains the macro and which one I have to download additionally. I would be very grateful for more detailed instructions.

best regards,

Gökhan Kilic

All comments

Gökhan

For the English forum:

Hello,

I have a situation where I want to import several Excel files (26) and link them together. I have already tried it via Wild Card, but many Excel files are skipped because the schema and length would not be standardised (warnings), which cannot be the case as all Excel files have a generic structure.

Merging the files 26x via an import node and then with a joiner doesn't quite work either.

If anyone has a suggestion for a solution, I would be very grateful!

Many thanks in advance,

Raj

@Gökhan Have you tried batch Marco. Because files with different schema are skipped if you read them directly.

Raj

@Gökhan you can take reference from this attached.

Multiple excels with different schema and different sheet names.yxzp

Gökhan

best regards,

Gökhan Kilic

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703