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 am new to this community and was facing issue while making workflow. I need to extract data from multiple excel files which has different sheet names but schema is name. Is there any option in Alteryx to dynamically rename those sheet name and consolidate data.
Hi Luke, Thanks for your reply. Let me explain what am trying to do. We have all the files in the same folder. Have attached worksheet1 and worksheet2 for your reference. Name of 1st tab in each worksheet are same but the problem is with the second tab where schema is same but sheet names are different. I want to get all data combined in the format shown in the attachment "Output2" where currency column is already there and we need to populate data accordingly from each file as per mentioned currency.
I did try Dynamic input tool + Directory tool but couldn't get success.
Hi Luke, Thanks a lot for your help. The problem is I am not able to run this workflow at my workplace as I have Alteryx lower build version installed - alteryx 2019.1.6.58192. Is there any way where I could run this workflow using this version. I tried making workflow using the given screenshots but couldn't get success. Anyways will try again. Again thanks for your help.