Challenge #438: Chronological Currency Balance

[AYXAcademy]

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:

• Changing Data Layouts
• Sorting Data

Good luck!

[binuacs]

Spoiler

[Kenda]

Spoiler

[griffinwelsh]

My solution

[zraposoaandm]

Spoiler

[Tofel]

Spoiler

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

[AkimasaKajitani]

My solution.

Spoiler

 

[RolandSchubert]

Spoiler

[rkakde]

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

Spoiler

[olga_strubbe]

Thank you, @messi007

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