Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Input tool reads the Excel file but the Select tool says No Data


I am inputting data from an .xlxs file and the input tool shows the data in the preview screen.  However, when i connect the Select tool it does not recognize any of the data.  Does anyone know why this may be happening?


Alteryx Certified Partner
Alteryx Certified Partner

The workflow needs to be run or refreshed so the information from the Excel file can be passed to the subsequent Select tool.


Run the workflow or press F5 to populate the metadata in downstream tools. 


LOL, i did run the workflow, but it says "No data available" still

Alteryx Certified Partner
Alteryx Certified Partner

Could you share the Excel file and/or your workflow so we can take a look?


THe file has sensitive information in it.  Would it matter if the tab i am trying to pull in is a pivot table?


If the excel coming in has a tab with pivot and then a raw data tab, I would bring in the raw data and then recreate the pivot portion using tools in Alteryx. This way if there are other calculations downstream that you need the data for then you have it.