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 built a workflow where I have joined and transformed some data from Source 1 and Source 2. I have gotten the output information I need from this. Source 3 is a highly customized excel file. My next step is to literally just drop the information in my output from Source 1 and 2 into certain rows/columns in the Source 3 file. It's not necessarily a join as there is nothing in Source 3. I just want to take the data from one place and put it into specific rows/columns of another excel file.
It's just defining the position of the fields. For example, I would want the data in column 1 of the output file to be entered into the excel template starting at B:2. Then column 2 from the output file needs to be entered into the excel template starting at D:2. So it isn't a continuous range (A:2 through D:2) that I need the data dumped into. I would need to specify which column from the output file I want to go into which column in the excel template.
Was there a resolution to this request? I have a similar issue. I have multiple data sources that I have joined and filtered to provide the required info but I need to move multiple columns from the join file into specific columns within an existing template.
I am going through an very similar scenario here and I could only think of one solution that comes straight to my mind which is using Dynamic Rename where you input the names of the columns using your template file. Technically you will not be filling up your template but rather copying it`s structure into your Alteryx output.
However, you will have to adjust the column names in your template to match those of your Alteryx output which can be done easily by using a select tool.
There might be a more convenient solution but this one is what I thought of straight away.