Greetings Alteryx Experts,
I've had a flow that successfully publishes data from Excel files on sharepoint to Tableau. It uses the concept of syncing sharepoint locally, then publishing to Tableau. That has not always worked whereas one of the file was not successfully updated locally so users were seeing old data. We recently upgraded Alteryx to 2021.4.2 and decided to try the tool Sharepoint Files input. I connected successfully to sharepoint but I notice the union tool always shows "input#1 was not initialized". I have three files located on sharepoint so there are three Sharepoint Files input tools, followed each by formula tool with very simple formula to define source, followed each by a dynamic rename tool because the first row was not coming through as column labels. These three data streams are then unioned using the errant union tool. The configuration for union is Auto Config by Name but when I look at Manually configure fields, I do see the proper column headings as expected. Why is data stopping at the union tool? I've tried putting a select tool before union, no change. How can I make the union initialize?