How can I combine two different data output together?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
phoebe_90
8 - Asteroid
‎05-20-2024
03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have two part of data, I want them out put in one sheet.
One part
| ffff |
| Report Period: Apr 30,2024 |
| Currency: CNY |
The other part
| B | C | D | E | F | G | H | |
| Amount | Over due days | 0 days | 1-30days | 31-60days | 61-90days | 91-120days | >120days |
| 1000 | 0 | 1000 | |||||
| 2000 | 10 | 2000 | |||||
| 3000 | 40 | 3000 | |||||
| 4000 | 70 | 4000 | |||||
| 5000 | 100 | 5000 | |||||
| 6000 | 140 | 6000 |
And between the two part data have one blank row.
Labels:
- Labels:
- Transformation
1 REPLY 1
harshendra
8 - Asteroid
‎05-20-2024
03:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
To put the data as it looks in an excel, use the reporting tools in Alteryx. Use the Layout tool to create the format and then the Render tool to put into excel.
