Creating values for dates in between

Question

Hi community!

I have the following data:

NameStart dateTermination dateSalaryDavid01.01.2401.02.24100 Jude02.01.23 200Lionel03.01.24 300Wright04.06.24 500

I am trying to create a flat data, where I want to see the actual cost of salary and the number of employees for the end of each month in 2024 (and also other years). Here is the output I am thinking:

NameDateSalaryEmployed or notDavid31.01.241001David28.02.2400Jude31.01.242001Jude28.02.242001Jude30.03.242001Jude31.04.242001

And the list goes on... Could you help me out?

Raj · Answer

@AlteryxPirasant 
my way of doing this 
kept it small and dynamic

hope this helps
mark done if solved.

1153.yxmd

binu_acs · Answer

@AlteryxPirasant One way of doing this

Date_Values_17062024.yxmd

ChrisTX · Answer

Check out:

* Generate Rows tool  Tool Mastery | Generate Rows - Alteryx Community générer les lignes zeilen generieren
* DateTimeTrim funtion using Trim Type lastofmonth   DateTime Functions (alteryx.com)

Chris