Copy pasting data in specific cell of existing excel template through alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Developer
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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)".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi mbarone,
The link does not solve the purpose.
Thanks!
Nischay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
is there a solution to this problem in the meantime ?
