It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.
Weekly Challenge
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
A solution to last week's challenge can be found here!
This week's Challenge come to us from @T_Willins!
Your tax group has advised you that the information they need is available only in a .TXT report. To properly import the data into a subsequent system, they need the data filtered and in a specified format.
First, match the ID no. from the totals rows to the corresponding detail lines. Then filter to only detail rows with a tax codes of P1 or P9. Format, sort order and field names on the output file must match the given output for the file to load correctly.
