How can you use the "R" tool to take details from 3 separate Excel files and combine?

[sonny-spencer]

Here is our required process. We are stuck on steps 3 and 4. Any assistance would be appreciated. Thanks!

Step 1 - Upload 3 password protected files to folder.
Step 2 - Process password to open files inside Alteryx.
Step 3 - Use R tool to take the details from the 3 files and combine into a single file and add one column to capture the file name on each line item.
Step 4 - Output as a single Excel file with a password.

We have installed the R Package and still run into issues, perhaps with the code (see attached).

Please help!

[apathetichell]

you didn't include the code. 

[BeckyV]

Here is the test file attached.

I have tried to install the R tool. but it still failed and showed the error messages.

Password: test

[apathetichell]

Did you install the package? Threre's lost of info here on how to install packages and how to troubleshoot packages not installing. 

[BeckyV]

I installed the package. But it still didn't work.