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 do not know whether it is possible in Alteryx or not. If yes, it is amazing.
I have a sample data as attached where in first sheet (Sample) contains some excel formula in columns C, D, E, F, G which is linked with 2nd sheet (Port List).
I just want to do find and replace in column A in Alteryx, and get output in the same column. When I output in the same column in the same file then Columns C, D, E, F, G would automatically update values as there is formula. If the question is not clear (please download the Sample data, and do find and replace (replace Mukalla with Mukalla Inland) in Column A in the first sheet and see how it works.
So, how can I get output where excel formula remains and I get the work done in Columns C, D, E, F, G by just doing find and replace in Col A with the help of Alteryx.
I went through all the posts, I think I need to do some more research on it. But, you gave a hope that it is possible.
One challenge, I am also facing that, In my sample I want two sheets.
Is there a way where we can keep this excel file in a folder then define the same path in output tool or define range in output tool where we want to do find and replace and change configuration to overwrite, then find and replace will be done only in col A and other columns and sheets remain same as it is ?
I would appreciate, if anyone can try to make a workflow, it would be very helpful in understanding.