5 Replies Latest reply: Nov 4, 2016 5:48 AM by Vitalii Shutkevych RSS

    "For Each" parameters from flat file

    Vitalii Shutkevych

      Dear colleagues,

       

      I have the following routine:

       

      For Each year in 2012, 2013, 2016

           For Each quarter in 'Q1', 'Q2', 'Q3', 'Q4'

                For Each comp in 33101, 46103, 66188

       

      Export:

      NoConcatenate Load

      *

      Resident XYZ

      Where

           Fisc_Year = '$(year)'

           and match (Fisc_Quarter, '$(quarter)')

           and business_unit = '$(comp)';

       

      Store Export into export\Export_$(year)_$(quarter)_$(comp).csv (txt);

       

      Drop Tables Export;


                    Next

               Next

          Next

       

       

      Question: How can I define the "For Each" parameters (marked red) in external flat file (lets say .xlsx), so that client does not have to go each time into a script editor and make changes?

       

      Thank you very much in advance.

       

      BR,

      Vitalii