NEED HELP with LOOP in ADDING(SUM) of MULTIPLE COLUMNS.

Hi All,

I am new to using a LOOP in Alteryx and would need help in the below example.

I want to add columns A and B. But only want either 0 or 1 in the output and it should keep adding if the count is greater than 1 into the next column (Sum_1, Sum_2, Sum_3).

IS THIS POSSIBLE TO DO?

This is just an example and I have a file with 10k records. Any thoughts or help would be appreciated. Thank You.

Workflow

Datasets

Developer

Input

Reporting

Settings

Error Message

Output

Custom Tools

Parse

Macros

Connectors

Common Use Cases

Transformation

Bug

Batch Macro

Help

Dynamic Processing

Join

Optimization

In Database

Predictive Analysis

Data Investigation

Machine Learning

Database Connection

Documentation

Power BI

Iterative Macro

Alias Manager

In-Database

Accepted answers

Qiu

@iamviraj13
Thank you for the detailed information.
I think below should help and I tried to be more dynamic.

0419-iamviraj13.yxmd

apathetichell

Slightly different take - note - got some weird results from generate rows so swapped to filter out the zero.

only1sshallremain.yxmd

danilang

Hi @iamviraj13

Here's a different technique.

The summarize tool get the largest number in the input. This is used to generate rows from to Max for each input. The formula tool sets the value to 1 or 0, based on the column number and sets the column name. After removing the Sum_0 values, the values are cross tabbed to final version

Dan

All comments

Qiu

@iamviraj13

Can you elaborate your logic? I am sorry but failed to understanda it.

For examle,

what is the definition of 'Counter'?

What is the definition of "Sum_1, Sum_2, Sum_3"?

iamviraj13

Hi @Qiu ,

So Column A and Column B are inputs.

Sum_1, Sum_2,Sum_3.......... are outputs

I need to add A and B. But if their sum is greater than 1 then I want the additional into next columns.

So if A+B = 3 then the output should be 1 , 1 , 1 as I only want 0 or 1 in Output column.
If A+B = 0 then it should be 0
If A+B = 2 then it should be 1 , 1.

Let me know if this is clear for you or if this is possible.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703