Challenge #438: Chronological Currency Balance

Hi Maveryx,

A solution to last week’s challenge can be found here.

This challenge was created by our ACE Mokhtar Bichiou. Thanks, @messi007 , for submitting your idea for this Weekly Challenge!

A client requested assistance with retrieving the history of a customer’s end-of-day currency balances from a given dataset. The goal is to display these daily balances in an output table, with the oldest balances on the left and the most recent on the right.

Your challenge is to find a solution that ensures the daily balances are always displayed in the correct chronological order, from the oldest (left) to the most recent (right).

Need a refresher? Review the following lessons in Academy to gear up:

Good luck!

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

Challenge_438_start_file.yxmd

Challenge_438_solution_file.yxmd

Data Preparation

Core

Basic

Accepted answers

All comments

Spoiler

Challenge_438_solution_BV.yxmd

Spoiler

Challenge_438_start_file.yxmd

My solution

Challenge_438.yxmd

Spoiler

438 Chronological Currency Balance.yxmd

Spoiler

Challenge 438.JPG

Dynamic or Unknown Columns in transpose, should ensure that any new columns are going to be presented in right format.

Challenge_438_Dom.yxmd

AkimasaKajitani

My solution.

Spoiler

スクリーンショット 2024-08-19 235411.png

Challenge_438_start_file_AK.yxmd

Spoiler

Challenge_438_solution_rsc.yxmd

Wonder if there is way to do this without using Dynamic Rename. Here's my solution:

Spoiler

Challenge #438 Chronological Currency Balance_Rishi.yxmd

Thank you, @messi007

This was a fun challenge! Please see my solution attached.

Challenge 438_Chronological Currency Balance.yxmd

Spoiler

I used a couple of date time parses which may not have been 100% necessary but good practice.

challenge_438_solution_EM.yxzp

Spoiler

2024-08-19 17_49_41-Alteryx Designer x64 - Challenge_438_CH.yxmd.png

Nice Challenge - here is my attempt.

Challenge_438_CH.yxmd

Nice little lunchtime appetizer to start off the week. My solution is attached.

Spoiler

Challenge 438 Image.png

Challenge_438_CH Solved.yxmd

Spoiler

Good Challenge here

Challenge_438_start_file.yxmd

Paridhi_Agrawal

Spoiler

Spoiler

Screenshot 2024-08-19 125808.png

Challenge_438_PA_solution.yxmd

Spoiler

Solution Attached

Screenshot 2024-08-19 101123.jpg

Screenshot 2024-08-19 101123.jpg

Challenge_438_start_file.yxmd

Spoiler

Challenge_438_Solution_AAA.yxmd

Spoiler

For fun, I tried out @AkimasaKajitani 's Field Sort macro

Challenge_438_start_file.yxmd

Fun quick challenge!

Spoiler

Transpose-Sort-CrossTab (then sorting and a bit of cleanup) Screenshot 2024-08-19 152212.png

Screenshot 2024-08-19 152212.png

Challenge_438_gg_finish.yxmd

My solution

Challenge_438_Whipple.yxmd

Spoiler

Date Headers Workflow.png

Date Headers Results.png

Challenge_438_date_headers.yxmd

Learned some new stuff with renaming headers. Good stuff. Also first time participating so if my formatting or response isn't typical, apologies.

Challenge_438_Solution.yxmd

Re-ordered!

AR_Challenge438_sol.yxmd

DaisukeTsuchiya

Spoiler

スクリーンショット 2024-08-20 060215.png

Challenge_438_start_file_DT.yxmd

Spoiler

Screenshot 2024-08-19 163001.png

Challenge_438_FINAL.yxzp

@messi007
Congratulations!

Spoiler

Challenge_438_start_file-Qiu.yxmd

Congratulation @messi007 !

My solution without Crosstab and Transpose.

Iteration Macro can increase data in horizontal direction(JOIN), in the most of case in vertical direction(UNION) though.

Spoiler

Append column one by one with Dynamic Select tool with the below expression

[Name]=ToDate(DateTimeAdd([#1],[Engine.IterationNumber],"Days"))&#8203;

Challenge_438_solution_gawa.yxzp

Done!

Spoiler

Challenge 438.png

Challenge_438_start_file_Alex Abi-Najm.yxmd

My solution

Spoiler

Screenshot 2024-08-20 091720.png

Challenge_438_start_file_WB.yxmd

My solution!

Challenge_438_start_file.yxmd

DONE.

Challenge_438_start_file_CZ.yxmd

Here is the solution!

Challenge_438_saran.yxmd