This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been trying to get my workflow to work whereby i am importing different excels, same sheet in each separate excel, with different schema. I have already tried everything on Alteryx forum (see below) and still cannot get it to work. i asked questions on those forums but the chat is dead and no one will assist.
Issue: I have 18 excel files with different schema (i attached 4 but i cannot do it manually for each one with 18 files). All excels have the same tab called Lead which has a list of investments and information about them. i am trying to pull in all investments from each excel with the name and the info in columns (Investment, Industry (FS), Unobservable input description) into my workflow. After that i was going to compile that information by investment using the name as the identifier.
This worked and i added it at the end of the workflow! Running into an issue now where my input data doesn't show up. see picture, both files and the same (different quarters) and no info comes in from the start. not sure what i did because it was working before
Everything works until the final step of combining everything. Everything coming in in to the join from both points, but no data is present for output J. I tried to combine them again using filters and still no data shows up.