I am looking to have Alteryx insert payments in periods based on payment frequency but I am stuck .
@Nilsend Can you provide some sample data and expected results for a better understanding?
@binu_acs See attached. I would like for the generated rows to be the same but for Year payments to only show on yearly payment lines
You can change your Generate Rows Tool "Loop Expression" to: DateTimeAdd([Date], 1, [Payment Frequency])
Would that accomplish what you are looking for?
Yes, I did that way originally but I would like to show the balances for each month in between without the payment being in each period
