What is a wildcard pivot and why does it matter?

Instead of naming the columns to pivot, you give a pattern such as 2024_*. Any column matching it is pivoted, including columns that do not exist yet.

It matters for maintenance. With a normal pivot, next month's file arrives with a new column and somebody has to open the flow and add it. With a wildcard, the flow keeps working.

It is one of the clearer examples of designing a flow so it survives contact with changing data rather than needing monthly attention.