Start Free Trial

Alteryx Designer Desktop Discussions

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

Combine multiple Excel files using and App

Jaloy_1973
8 - Asteroid

Hi, 

 

I was uploading and combining diferent Excel files (monthly data), all with the same estructure and just one sheet.

I used the input tool and wild cards like this:

 

C:\Users\JA\OneDrive - ADMINISTRATIVOS\Proyecto Alteryx\2024\PQ_DIARIO GRUPO\INPUTS\*.*

 

This formula works perfectly, but I wanted to create an App to select any folder and its content in the future and automatise the process.

I've tried with the List Box tool, selecting all the files of the folder but I couldn't make it work.

 

Any suggestion?

 

Many thanks in advance,

Jordi

2 REPLIES 2
binuacs
21 - Polaris

@Jaloy_1973 you can try something like below

image.png

Jaloy_1973
8 - Asteroid

Many thanks, it works perfectly.

 

Best,

Jordi

Labels
Top Solution Authors