Filtering based on the row value

[ebobo]

Hello, I would like to achieve the following result in alteryx.

Select only columns where the row equals 1.

See Example below.

[gawa]

hi @ebobo 

It is difficult to directly filter the columns depending on value, so first transpose data into vertical shape, and filter data(value=1), and cross-tab would work.

Pls note that if your data is having multiple rows, logic will be much complicated.(should we filter the column with row1=0 and row2=1?...like that) 

[binu_acs]

@ebobo Transpose and cross tab

[ebobo]

The problem is that I have a lot of rows, so in that case it's maybe easier to filter manually with select tool?

[nagakavyasri]

@ebobo