AnsweredAssumed Answered

Iterating through a dictionary

Question asked by jborgion Champion on May 6, 2019
Latest reply on May 7, 2019 by bixb0012

I have a dictionary in the form of:  

year2018 = {'jan18':(1,2018),'feb18':(2,2018),'mar18':(3,2018), 'apr18':(4,2018),
            'may18':(5,2018),'jun18':(6,2018),'jul18':(7,2018),'aug18':(8,2018),
            'sept18':(9,2018),'oct18':(10,2018),'nov18':(11,2018),'dec18':(12,2018)
            }

I have a data table where each record has Month field and a Year field.  I would like to iterate through my dictionary so that while key = jan18, I select records from my table where Month = 1 and Year = 2018, and then export those records to a stand-alone table called jan18: then move on to key = feb18, etc etc.  I've tried a couple different approaches, but still not quite getting what I want. Any suggestions are appreciated. (Using a dictionary is cool, but I'm open to all suggestions...)

Outcomes