Looping

Question

Hi everyone

I'm new to Alteryx and need some help.

i have this snapshot data which contains loans and bonds data.  we need create card for each loan that count interest and paid amount.

1 1st need to count the loan based on Coupon Frequency = annual 1 time year - semi annual 2 times year and so on until the Balance of discount/ Premium gets = 0

need the card result shown like this:

No.150    Face Value                  400,000                                       Coupon Frequency Semi Annual     Tenor_Frequency                            60    Bond price                  394,721    Coupon Rate5.75%    Discount/ (Premium)                       5,279          Interest_based on frequency                  700,000    Issue Price                       98.68    Discount/ (Premium) Discount     Discount/ (Premium)_Based on frequency                            88    Market rate (Yield)5.84%    Amortization expense for 2022 and before                             -      Amortization expense for 2023                             -      Amortization expense for 2024                          170    Carrying amount as of 30 December 2024                  394,891 FALSE   Interest expense for 2022 and before                             -      Interest expense as of 2023                             -      Interest expense as of 2024               1,351,389                                                                                            PeriodInterest paidInterest ExpenseDiscount/ Premium amortizationBalance of discount/ Premium

(Balance of discount/ Premium - Discount/ Premium amortization)

Carrying value

(Carrying value +Discount/ Premium amortization)

1/16/2024                                                     5,279                  394,7217/15/2024                  700,000                              700,000                                                            88                                                  5,191                  394,8091/13/2025                  700,000                              700,000                                                            88                                                  5,103                  394,8977/13/2025                  700,000                              700,000                                                            88                                                  5,015                  394,9851/11/2026                  700,000                              700,000                                                            88                                                  4,927                  395,0737/11/2026                  700,000                              700,000                                                            88                                                  4,839                  395,1611/9/2027                  700,000                              700,000                                                            88                                                  4,751                  395,2497/9/2027                  700,000                              700,000                                                            88                                                  4,663                  395,3371/7/2028                  700,000                              700,000                                                            88                                                  4,575                  395,4257/6/2028                  700,000                              700,000                                                            88                                                  4,487                  395,5131/4/2029                  700,000                              700,000                                                            88                                                  4,399                  395,6017/4/2029                  700,000                              700,000                                                            88                                                  4,311                  395,6891/2/2030                  700,000                              700,000                                                            88                                                  4,223                  395,7777/2/2030                  700,000                              700,000                                                            88                                                  4,135                  395,86512/31/2030                  700,000                              700,000                                                            88                                                  4,047                  395,9536/30/2031                  700,000                              700,000                                                            88                                                  3,959                  396,04112/29/2031                  700,000                              700,000                                                            88                                                  3,871                  396,1296/27/2032                  700,000                              700,000                                                            88                                                  3,783                  396,21712/26/2032                  700,000                              700,000                                                            88                                                  3,695                  396,3056/25/2033                  700,000                              700,000                                                            88                                                  3,607                  396,39312/24/2033                  700,000                              700,000                                                            88                                                  3,519                  396,4816/23/2034                  700,000                              700,000                                                            88                                                  3,431                  396,56912/22/2034                  700,000                              700,000                                                            88                                                  3,343                  396,6576/21/2035                  700,000                              700,000                                                            88                                                  3,255                  396,74512/20/2035                  700,000                              700,000                                                            88                                                  3,167                  396,8336/18/2036                  700,000                              700,000                                                            88                                                  3,079                  396,92112/17/2036                  700,000                              700,000                                                            88                                                  2,991                  397,0096/16/2037                  700,000                              700,000                                                            88                                                  2,903                  397,09712/15/2037                  700,000                              700,000                                                            88                                                  2,815                  397,1856/14/2038                  700,000                              700,000                                                            88                                                  2,727                  397,27312/13/2038                  700,000                              700,000                                                            88                                                  2,639                  397,3616/12/2039                  700,000                              700,000                                                            88                                                  2,552                  397,44812/11/2039                  700,000                              700,000                                                            88                                                  2,464                  397,5366/9/2040                  700,000                              700,000                                                            88                                                  2,376                  397,62412/8/2040                  700,000                              700,000                                                            88                                                  2,288                  397,7126/7/2041                  700,000                              700,000                                                            88                                                  2,200                  397,80012/6/2041                  700,000                              700,000                                                            88                                                  2,112                  397,8886/5/2042                  700,000                              700,000                                                            88                                                  2,024                  397,97612/4/2042                  700,000                              700,000                                                            88                                                  1,936                  398,0646/3/2043                  700,000                              700,000                                                            88                                                  1,848                  398,15212/2/2043                  700,000                              700,000                                                            88                                                  1,760                  398,2405/31/2044                  700,000                              700,000                                                            88                                                  1,672                  398,32811/29/2044                  700,000                              700,000                                                            88                                                  1,584                  398,4165/29/2045                  700,000                              700,000                                                            88                                                  1,496                  398,50411/27/2045                  700,000                              700,000                                                            88                                                  1,408                  398,5925/27/2046                  700,000                              700,000                                                            88                                                  1,320                  398,68011/25/2046                  700,000                              700,000                                                            88                                                  1,232                  398,7685/25/2047                  700,000                              700,000                                                            88                                                  1,144                  398,85611/23/2047                  700,000                              700,000                                                            88                                                  1,056                  398,9445/22/2048                  700,000                              700,000                                                            88                                                     968                  399,03211/20/2048                  700,000                              700,000                                                            88                                                     880                  399,1205/20/2049                  700,000                              700,000                                                            88                                                     792                  399,20811/18/2049                  700,000                              700,000                                                            88                                                     704                  399,2965/18/2050                  700,000                              700,000                                                            88                                                     616                  399,38411/16/2050                  700,000                              700,000                                                            88                                                     528                  399,4725/16/2051                  700,000                              700,000                                                            88                                                     440                  399,56011/14/2051                  700,000                              700,000                                                            88                                                     352                  399,6485/13/2052                  700,000                              700,000                                                            88                                                     264                  399,73611/11/2052                  700,000                              700,000                                                            88                                                     176                  399,8245/11/2053                  700,000                              700,000                                                            88                                                       88                  399,91211/9/2053                  700,000                              700,000                                                            88                                                         0                  400,000

KGT · Answer

Your dates are already converted. You are feeding in 2026-03-22 and it is expecting %d-%m-%Y. You don't need to convert that date and so you may need to filter out the dates that are already fine, or put a conditional statement in so that you don't try and change the ones that are already fine.

Fedahh · Answer

Thank you so much!

i tried the solution with sample data and it work good, but when i try it on original document it give me this error and i try different format same error.

any explanation why this not working?

Gaurav_Dhama_ · Answer

And here is the workflow with dates.

Bonds workflow.yxzp