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.
You will not be able to do both of those with Alteryx alone. You will need a VBA Script / Macro that Alteryx can trigger after the data is written to the file. There are a number of post dedicated to running VBA with Alteryx so no need to rehash here, but below is the link to one of the most useful IMO.