SOLVED
Data Duplication by Date value
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
Mostafa_Anwar
8 - Asteroid
‎09-07-2019
05:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
I'm trying to find the best way to accomplish this, How to duplicate data based on date value Ex.
i have this dataset and i want to add a new column called Date, and all these rows will be duplicated based on date as per the attached excel sheet example.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
danilang
19 - Altair
‎09-07-2019
07:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Anytime you're looking to repeat a group of records for each record in another data set(Cross or Cartesian Join), the Append Fields tool is your best option. It appends all the fields from the 2nd set to the 1st, duplicating rows as required
The extra tools in the workflow are there to provide index values to sort the final output in the proper order.
Dan
‎09-08-2019
01:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome! Many thanks Dan