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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
I have designed a workflow which output to an excel file. Column range is from A to D which is fixed as the fields are fixed. Row range may change when i run the work flow on a daily basis. I have some formula in the excel file from column G to H. I have 10 sheets in total.
(1) When i run the query today, old output file which was run yesterday should be deleted and new file should be in column A to D. Rows will change on a daily basis.
(2) Formula's which i have inserted should remain in all the 10 sheets.
For this scenario I would suggest using something similar to Google Sheets' IMPORTRANGE Function, except for Excel. Essentially what you do is create a dummy file, probably a csv, that you will query in your actual file. The dummy csv will be what Alteryx will overwrite every time you run your workflow. The query in your acutal file will then read from this csv, essentially creating a duplicate. The key difference, however, is that this duplicate can be used in formulas in other sheets and the formulas will not break. If you were to skip this dummy file step, any formulas you had would break when you overwrite your original file with Alteryx.