Iterating table fields to create individual Shapefiles

Question

I am trying to create individual shapefiles from a single table that contains the following:

• Weather Station Names
• Station XY Cordinates
• 31 individual field columns of daily data for each weather station

I am trying to use the iterate field values from another spreadsheet that contains only a single column the date of the weather data that I want to create each individual shapefile. The dates in that spreadsheet match the column field heading in the spreadsheet that contains the daily data.

I am getting an error in the Make XY Event Layer when I try to set the "Z Field" to "Value" for the iteration process. I have attached an image of my model below.

Any advice on how to get this thing to run?

Answer 1

If you are trying to create a shapefile for each station with these 31 fields (daily weather readings) and your rows contain weather station records, you are making a logical mistake. Your Make XY Event tool expects two fields to yield locations but Iterate Field will return only one (field, field value). So, the tool becomes blank expecting to be introduced correct input parameters.

Instead of iterating fields, you should use Iterate Row Selection. However you should Join your data at the outset or later. Assuming July_ETo_gdb is your station table, first Join this to your other dbf and place row iterator to this station table. Then use XY Event tool which will carry over the row values for then shapefile output.

Lastly Feature Class to Shapefile may not be the right choice here, you should be using Copy Features tool instead, I think.