Isolate single column using If statement or filter?

Hey guys,

Is it possible to isolate a single column using an IF statement? I don't want to use the Select tool to deselect the columns I don't need as the column I need will be conditional based on another column.

For example, if [Period] = P11, then I would like to isolate the P11 column by itself. If Period = P12, then isolate P12. This would happen many times and it isn't feasible to manually deselect using the Select tool.

Account	Account Number	P11	P12	Period
Sales	1	0.1	0.3	P11

Workflow

Accepted answers

binu_acs

@BenJones13 updated the workflow

Transpoe_280323.yxmd

All comments

binu_acs

@BenJones13 One way of doing this by transposing the data and filter out the records which you want

Transpoe_280323.yxmd

SPetrie

When you say isolate, do you mean you want only the column specified in the Period column to be left for the next tool to act upon, or you just want to single out the column for use later in the flow?

In the example above, do you want a single column of P11 since that was was in Period, or do you need all columns to continue through the flow but we are just using P11 as the focus?

BenJones13

Hi @SPetrie,

Sorry for not clarifying! @binu_acs Thanks for the speedy reply but as @SPetrie mentioned, I want the single column of P11 by itself.

It would go from this

Account	Account Number	P11	P12	Period
Sales	1	0.1	0.3	P11

To this, based on the condition aforementioned:

P11

0.1

binu_acs

@BenJones13 updated the workflow

Transpoe_280323.yxmd

SPetrie

Another method is to use a combo of dynamic rename and dynamic select.

I use a dynamic rename to update the description of the column named in the period column and then use a dynamic select to remove any column that doesnt have the "keep" description.

select.yxmd

BenJones13

Thank you so much for the help! I think I'll go ahead with this one @binu_acs, seems simple and replicable to my untrained eyes!

Thank you very much @SPetrie too. Really appreciate the speedy and helpful replies.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703