We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
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.