Static Input Sheet - Excel

Question

Hi all, can someone from the community guide me how to load only a single sheet from an excel file which contains 4 sheets but I want to automate the process in which the Workflow selects only the selected sheet everyday.

Ex - Sheet 1 - Name

Sheet 2 - Description

Sheet 3 - Join

Sheet 4 - Feed

I will receive a file which has only these sheets present in that file which is static and now I want only Sheet 3 - Join everyday, the Workflow should select only the 3rd sheet - Join everyday, I don't want to manually select the sheet name everyday, how can I perform this in Alteryx

Bren_Spill2 · Answer

@Kaish - the following steps will get you what you need:

* Add an Input tool to the canvas
* Hit Set Up a Connection
* In the Data connections window, select Files from the pane on the left, then hit Select file
* Browse to the file you want and select Open
* You will then see the Select Excel Input window from the screen shot below. Here's where you'll select Sheet3 from the dropdown
* Hit OK and then you can run the workflow

Once you set this up, you won't have to change the configuration again as the file name is staying the same (assuming Sheet3 is named consistently as well).

Kaish · Answer

Hi @Bren_Spill2 , thanks for the reply, Actually everyday a new file will be uploaded in the drive with the same name, I don't have to consolidate I just have to run my flow on the same logic to get the output everyday, like automating a file everyday to get some additional data out of the file, so everyday a new file with the same name will be added to the input tool and then from there it should pick sheet 3 everytime

Bren_Spill2 · Answer

@Kaish - Once you connect the input tool to the file and select Sheet3, you won't have to change the configuration of the Input tool as long as the file remains in the same location.

Are you receiving a new input file every day? If so, are you consolidating it with the previous day's data?