Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I believe I found a 'dynamic' way using the core tools. Namely split to rows and cross-tab/transpose pivots. At least under the assumption the values will always be delimited with a pipe.
I tried a long regex expression for 'fun', but the third record's null client id got me. The expression I tried was (\#|\d{4}|"") but it fails to match. My solution was to make the entire clause optional as (\#|\d{4})*. Pretty much the opposite of dynamic but was good practice.
