Need help

[c_sontsakiteu]

Hello I am new to alteryx designer and I have a problem with the practice, I have two files named "2022 Gross Revenue.xlsx" and "2021 Gross Revenue.xlsx", the exercise is to :

Bring in data from the Gross Revenue 2022.xlsx, and Gross Revenue 2021.xlsx files, pulling sheet1 from each of those.

Use a wildcard in the file name to bring them both in with one Input Data tool, and output the filename for reference using an option in the configuration window.

I don't really understand the exercise and is there a tool which can upload a multiple file ? 
I need help please.

Thank you.

[Luke_C · Accepted solution]

Hi @c_sontsakiteu 

The wildcard input just means leveraging an asterisk in your input tool. To do this just set-up the normal input tool for one of the files, make sure it works, then in the file path of the input tool change it to \*Gross Revenue.xlsx (or \Gross Revenue*.xlsx depending on your file names, you note them differently in your post). This tells alteryx to pull all the files that match that pattern.

[c_sontsakiteu · Accepted solution]

Thank you. I tried it and it works.

[Luke_C · Accepted solution]

Hi @c_sontsakiteu  Great! Remember to mark the solution if you're all set.