dynamically selecting month column

Good afternoon community,

I have a dataset containing sales values for each month. Each column header is a number referring to the month it represents (eg Jan is 1, Feb is 2 etc).

From the filename, I'm able to extract the month name for which I should be running the report (eg. September).

How can I have Altreyx Identify that I am after column '9', rename it Sales Value, and exclude all the other month columns?

I had a look at a solution using the dynamic rename tool using the formula option but couldn't figure out how to get a variable working.

Thanks

Date Time

Common Use Cases

Accepted answers

MarqueeCrew

@Elias,

The workflow will read in multiple records and produce 1 column of output for only the column of data with a numeric value matching an incoming MONTH field.

A record number is assigned to each incoming record. The data is transposed to Record ID + MONTH + Column Name + Column Value rows. If the Month Name = the "formatted" month number, then the row of data is kept. The current month data is then cross tabbed back to a single column of data applying a name of Sales Value. The record number is removed and you are left with a single column of values.