We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Hey there @Adam_Dooley
Your solution helped me identify the error in my solution. I was using a directory tool followed by the dynamic input, but when it pulls the .sz extension--(Alteryx Spatial Zip File), it populates the same incorrect value for the num field for all records.
I was surprised that the tools pull different values. Does anyone know why? Wait a minute; I found out why; I changed the configuration of the dynamic input to read and change Entire File Path, and it pulled the correct values as seen below.
Here are 2 potential solutions (see spoiler for details)