Copy and Paste on specific cell in excel using Alteryx

Question

Dear Community,

Can you help me how to copy paste data from one excel to another using excel.

Data need to be copy and pasted in specific cells of the output excel.

InputMetricValueAmount10Account20Amount-3MOB5Account-3MOB9

Output   MetricJan-20Feb-20Mar-20Amount  10Account 20 Amount-3MOB5  Account-3MOB9

Please help me in resolving the above.

Thanks

hfibrahim · Answer

Hi,

did you find the solution for this. if yes can you please help me with the workflow. thank you!

Dr_Strange · Answer

Hi Mceleavey,

Thanks for the help, but it does not solve the purpose.

The problem is not just copy pasting the values and the cell reference is also not fixed.

For every month the cell referencing gets updated and we need to copy paste in new column.

Below is the problem:

Input:

* On a monthly basis we create a regulatory report which have multiple metrics in the same.
* There is a standard template for the report.
* And we get the data(input) in form of excel sheet with 2 columns: 1)Metric name 2)Metric value.
* Attached dummy input template for reference.

Calculation:

* We need to copy paste the values(from input file to the template) in the new column for every new month.

Challenge:

* For every month a new column should get inserted , and there are certain metric which refer to previous months data.
* For example

We have the input data for July month as:

Total Outstanding

10

Open Accounts

20

3MOB

5

6MOB

9

* The data can go from 3MOB to 36 MOB( i.e. needs to be pasted 36 months prior).

Output:

The output file is a report template that needs to be filled.

So without changing the format of the template can we paste the values from input excel to the template through alteryx.

Dummy template attached for reference.

mceleavey · Answer

Hi @Lalit_c ,

ok, this is definitely a pivot as it would make it dynamic. This is not Excel, thankfully, where everything is manual copy and paste. When I say pivot, I mean the true pivot, which is to rotate the data around a point.

You don't have the dates listed so you need manually create them.

In this example I simply created the dates as a separate text input and joined them to the associated records:

I then cross-tabbed the data into the correct format:

Workflow attached.

I hope this helps,

M.

solution_Lalit_c.yxmd