Data Duplication by Date value

Question

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.

Should Be looks Like.xlsx

danilang · Accepted Answer

Hi @Mostafa_Anwar

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