Renaming some columns

Question

So, in the end of my project i have a table, but i need the column's names to have a date value that i got from another little table, so i got an example ready down there:

That's the main table with my data and the columns with the "wrong" names

ClassToday's lootToday's EXPYesterday lootYesterday EXPLast Friday LootLast Friday EXPMageGold50Gold30Mage45RogueGold60Gold45Knife55RangerItem25Nothing0Bow75

And thats my other little table, with the date values i want to use

TodayLast FridayYesterday21/06/202118/06/202120/06/2021

So, basicaly what i need is to change the first table "yesterday's loot and yesterday's EXP" for the value 20/06/2021, and that with all the other columns with their respective days.

Someone would know how to help me please? :3

MarqueeCrew · Accepted Answer

@TormentMaker ,

I modified Today in your other table to:  Today's.

Using a few tools to align the data, I came up with the following workflow:

Cheers,

Mark

Jonny · Accepted Answer

Hi @TormentMaker ,

I think this would do the trick - transpose with Find & Replace:

see attached example from the data you provided.

Let me know if it helps?

cheers!

BR/Jonny

KarolinaRoza · Accepted Answer

Hi @TormentMaker ,

I little bit different understood your problem, instead of taking FIXED values from the file (I mean current TODAY, current YESTERDAY, or last Friday) I made it more dynamic.

It means that if you will run in in few days for example in next week;  it will replace with current day, yesterday and last Friday (06/25/2021).

I hope it will be also beneficial for you.

Karolina

HomesickSurfer · Accepted Answer

Hi @TormentMaker

See attached.

Transpose, Increase field size, find-replace, cross-tab...then...a series of Dynamic Rename regex formulas to replace the _'s as a result of the Cross-tab.

Lemme know if this works.