How to run the same code on different columns in the same workflow

Pankhudri20

Hello,

I have to flag warnings for certain conditions for the attached sample data.

For example: issue warning "if C1<1 lasts 1 hour".

However, there are C1....C11 column values in the data.

I calculated running sum total for the rows where C1 < 1 and will check for time equal to or greater than 60 minutes.

Can you please tell me how to repeat the same process for other columns optimally?

Please find the sample data and workflow attached for reference.

Thank you

Pankhudri

Sample_data_alteryx_1.xlsx

Sample_IssueWarnings.yxmd

Datasets

Input

Output

Custom Tools

Parse

Date Time

Help

Optimization

Expression

Accepted answers

All comments

Pingu

If you want do do all columns at once with one formula you probably need to use the transpose tool.

I believe this challenge very much describes what you need (you can look at peoples solutions):

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-271-Dynamic-Double-Dip/td-p/769252

So you could create a lot of different formulas or do it all at once with a transpose/crosstab before the formula tool.

Pankhudri20

Hello,

Thank you for your quick response.

I have attached the sample data excel file if you want to check my workflow.

I will look at the solutions in the link attached.

Regards,

Pankhudri

jgv27

Hi @Pankhudri20,

I had a look at your question and think I over-engineered a workflow for your purposes (after looking at what @Pingu proposed).

You are more than welcome to take a look at the workflow (batch macro) that I've put together. It is however not optimal, as I can not get it to batch all the "C"-columns only once. At the moment it works through an average option in the summarize tool, and can definitely be optimized further.