Looking for formula to be used in workflow which is equivalent to count if

Question

Hi,

I am looking to create a flow placing a formula equivalent to Count If formula with condition. Like if data as employee name repeated in multiple months i want a count details in separate month tab.

I have attached the file the output required for this flow.

Raw Data.xlsx

pratiksalian · Answer

How to merge two files one file does have a list of employees and Jan-Dec Column and the second file where you have provide the alteryx flow. Final output data will have all employee name and in front of them all months whichever month have data can be populated in the output

DawnDuong · Answer

hi @pratiksalian

One possible way to keep the header dynamic is use a combination of Transpose and Cross Tab tools.

I have enforced the rank order of the month (e.g. Jan comes before Feb and Mar) by using numeric month instead. This works if you only have 12 months, if you have multiple years of data, then the period needs to be uniquely identified by both month and year.

Also I suggest that you keep the column header unique E.g. instead of having many columns named "Unmatched", which makes it difficult later on if you want to process in Excel (imagine using Index function...). One possible way is to concatenate the Unmatched suffix to the month name.

Hope this helps you.
Dawn.

Simulated Countif.yxmd

pratiksalian · Answer

Thank you for the response.

Just wanted to understand the formula which is been pasted to create the header for unmatched is it possible i can header for all months irrespective if the data as the month or not. Because i see the formula which is been currently updated is creating header for the month for which data is there.

Also comment cannot be constant so is there any alternative if the comment column as any data it should be considered as matched and which is blank it should be considered as unmatched