Need to prompt for base month and comparison month associations

[A1]

I am working with historic (base) and forecasting (comparison) files. Each file has an ID and field names associated with months (Jan, Feb, Mar, etc.) that contain activity count values. The months present in each file can be as few as one, but no more than 12 - so there is no year/date information, just month. Often the identical months will be compared (Jan, Feb, Mar to Jan, Feb, Mar); however, there will be times when the historic months considered are JUN, JUL, AUG (say in 2020), but the comparison months need to be FEB, MAR, APR (say in 2021). I need to prompt the user to select which months in the base file should line up with which months in the comparison file.

How can this be accomplished?

Thanks in advance.

Base

ID	JUN	JUL	AUG
A1	15	15	15
A2	25	25	25
A3	5	10	15

Comparison

ID	FEB	MAR	APR
A1	15	15	25
A2	20	25	25
A3	5	15	10

[HomesickSurfer]

Hi @A1 

Here's my approach...allowing selection of the ID and Base/Comparison months.

Workflow attached.

Hope it works for you.

Workflow

App questionsResults

[HomesickSurfer]

Hi @A1 

Does my solution work for you?