How to concatenate 2 data sets
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
izzy25593
5 - Atom
‎08-16-2023
02:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have 2 excel data sets, that are exactly the same. The only difference in the files is the months data. We currently use power query to put together but hoping to use Alteryx to combine them.
I've set up the two inputs connected to the excel files, then a union on name.
Its running but its taking a long time. There's about 6000 rows in one file, 130000 rows in the other. 100 columns.
Is there something i'm doing wrong?
Labels:
- Labels:
- Datasets
1 REPLY 1
binuacs
21 - Polaris
‎08-16-2023
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@izzy25593 You can also use the wild character option in the input tool if the files are of the same schema
