Data Reshaping - Data Padding

The reshaping before and after looks are in the screenshot below. The BEFORE dataset lists a client’s program history - one program per row along with the program’s start and end dates.

After the reshaping I want to fill in the months between the month of the start date and the month of the end date.

I want to know how to do it in EasyMorph. Thank you.
data reshaping

1 Like

In your example “Intake program” in the BEFORE table starts in March, but in the AFTER table it starts in April. Also in BEFORE it ends in July, but in AFTER it ends in June. What’s the logic for calculating the Date column in AFTER? Can two programs have the same Date in After?

In general, it seems that you will need to use the “Interval match” transformation.

Thank you for the quick response.

Joe stayed with the community outreach program for 19 days in March (>=15 days), and stayed with the Intake program for 12 days only in March(>= 15), so “March 2015” is assigned with Community Outreach program.

I will give “interval match” a try. Thank you very much for your time.

Thanks for the explanation. I’ve made a quick example (see below). Hope it helps.

Book1.xlsx (9.1 KB)
interval.morph (4.9 KB)

Topic moved from #support to #uncategorized.