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

[Puneet13]

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]

@Puneet13 please attach a sample of your data so we can assist in constructing the workflow for you.

[Puneet13]

Prod_Year_Of_Audit	Prod_Month_of_Audit	Prod_Business	Prod_Manager_Name	Prod_Employee_Name	Prod_Audit_Count	Prod_Critical_Errors	Prod_Procedural_Errors	Prod_UniqueID
2022	September	CCCD	ABC	ABC	1	0	0	ABC
2022	April	CCCD	DEF	DEF	2	0	0	DSN
2022	Jan	CCCD	IJK	IJK	3	0	0	PWD
2022	Feb	CCCD	LMN	LMN	4	0	7	SST
2022	March	CCCD	OPG	OPG	5	0	0	KOT
2022	May	CCCD	RST	RST	6	0	0	MNA
2022	Jun	CCCD	UVW	UVW	7	0	0	DDD
2022	July	CCCD	XYS	XYS	8	0	0	SSS
2022	November	CCCD	MNO	MNO	9	0	0	KKK
2022	October	CCCD	MNO	MNO	10	0	0	KKK
2022	December	CCCD	MNO	MNO	11	0	0	KKK
2023	September	CCCD	ABC	ABC	12	0	0	ABC
2023	April	CCCD	DEF	DEF	13	0	0	DSN
2023	Jan	CCCD	IJK	IJK	14	0	0	PWD
2023	Feb	CCCD	LMN	LMN	15	0	7	SST
2023	March	CCCD	OPG	OPG	16	0	0	KOT
2023	May	CCCD	RST	RST	17	0	0	MNA
2023	Jun	CCCD	UVW	UVW	18	0	0	DDD
2023	July	CCCD	XYS	XYS	19	0	0	SSS
2023	November	CCCD	MNO	MNO	20	0	0	KKK
2023	October	CCCD	MNO	MNO	21	0	0	KKK
2023	December	CCCD	MNO	MNO	22	0	0	KKK

[rzdodson]

@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.

[Puneet13]

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

[rzdodson]

@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.