Copy pasting data in specific cell of existing excel template through alteryx

[Dr_Strange]

Dear Community,

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

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

For example:

We have the input data for july month

Input
Metric	Value
Amount	10
Account	20
Amount-3MOB	5
Account-6MOB	9

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

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

	Retail/Wholesale	Retail
	Region	Barclaycard
	Country	Germany
	Consumer/Business/Affluent	Consumer	Region
	Secured/Non-Secured	Unsecured	Country
	Product1	Cards	Product1
	Product2	Germany Cards	Product2
		Unit	Data	2012-01	2012-02	2012-03	2012-04	2012-05	2012-06	2012-07
	FX Rate	#        n/a	Sum of FX Rate	1	1	1	1	1	1	1
Portfolio Metrics: Stock	Total Outstandings	£        Stock	Sum of Total Outstandings							10
Open Accounts	#        Stock	Sum of Open Accounts							20
3MOB	£        Stock	Sum of Amount at 3 MOB				5
6MOB	#        Stock	Sum of Account at 6 MOB	9

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

If anyone can help me with the above problem.

Below is the template format for reference.

Thanks!

Nischay

[mbarone]

If you follow the thread here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-a-specific-range-in-Excel/td... , it will explain how to output to a specific range of cells.  To preserve the formatting, you'll additionally want to check option #6 in the configuration of the output tool, "Preserver Formatting on Overwrite (Range Required)".

[Dr_Strange]

Hi mbarone,

The link does not solve the purpose.

Thanks!

Nischay

[Dr_Strange]

We are facing one business problem and wanted to explore alteryx to solve the same.

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 eg:

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. (Values that are added are highlighted in yellow.

[Momo_2612]

is there a solution to this problem in the meantime ?