Hi Community,
I am stuck with a problem to solve and was hoping if someone can help out.
I have a file coming in every week & only the date (header) column is going to change. Rest the format of the file is the same. I need to add date column to the output & rename the columns which have dates in them.
Attached is how input and output looks like. I had a crack at it but unsure how it will work end to end.
Can someone please help out? Thanks in advance,
¡Resuelto! Ir a solución.
Thank you, @udles5666 (I can't really tag you because I have not yet earned the Asteroid badge) for giving me the opportunity to post my first solution and also learn something new (Find Info tool and the use of regexp_match in the Formula tool used by @ArtApa). 😀