Macro To Help filter the data based on Month and Year Field in DataSource

Question

I need and help where in i have data from 2020 Jan and need to upload into SQL database, Due to heavy load unable to load it in a one go, So I need help to create a macro which help to Filter the data based on "Year" and "Month" field and one by one upload the data based on filter into data source. Help me to provide workflow with example.

rzdodson · Answer

@Puneet13 that specific anchor is to show if there are any records that did not pass through the iterative macro - it is a requirement for iterative macro construction. If we told the iterative macro to run 50 times but we have 100 unique dates, then you'll see 50 records in that L anchor since they did not pass through the macro. Since the output creation is contained inside the iterative macro itself, you will only see one output-style anchor in the main workflow.

Puneet13 · Answer

It is showing no value. Correct me if i missed something.

rzdodson · Answer

@Puneet13 there are two solutions that are in the attached file. The first is a batch macro solution, while the other is an iterative macro solution. For both, they end with creating an xlsx-based output. Hopefully that gets you pretty close to what you are needing to have accomplished.

If you are needing to stream this data in to a database instead, will likely need some more information (e.g. name of the database) so the workflows can be augmented to fit your specific need.

Solution.yxzp