Entering data to SharePoint list based on Months

Question

Hello All,

I need to create an alteryx workflow which will pull the data from the database. Now I've a query to pull the records, but in the workflow a copy of the data will be loaded for the current month, and all future months.

For example -  I've 20 records in the database. If the workflow is running in June, data should be populated for June – November (6 months forward). There would be 20 records for each month. Only difference would be the month.

And If I'm running the workflow in July, It should delete the data for June month and populate the data from July to December ( 6 months)

Please advise

binu_acs · Answer

@swapsingh2712 one way of doing this

RoGenerateTool_01_06.yxmd

swapsingh2712 · Answer

Hey @binu_acs

I've attached the sample dataset. In the dataset I've created 2 sheets named as Sample Input and Sample Output

In the sample output you'll find the expected output. So this new month column should be generated.

If I'm running the workflow, it's giving the output till November.

If I'll run it in July, It should give output till December.

The dataset will be same, only thing that should change is month.

BR

swapsingh2712

Sample Data.xlsx

binu_acs · Answer

@swapsingh2712 My understanding was wrong that why I suggested dynamic select. If you want to generate rows for each month you need to use the generate tool. My question for the above use case are you expecting 2 rows for the months starting June to November? Can you provide a sample output for the given input ?