Hi All, I am working on a use case where I need to select some columns based on value of one of the column in row. The sample example shown below: Reference IDNameIndicatorStore1Address1Store2Address2ID1A1StoreXAddressXStoreAAddressXID2B1StoreYAddressYStoreBAddressYID3C2StoreZAddressZStoreCAddressZ So, when the indicator is 1, I need to take forward columns Reference ID, Name, Store1 and Address1, and when the indicator is 2, I need to take forward columns Reference ID, Name, Store2 and Address2. Then I have big business logic to work on these columns. Is there any simple way to achieve this? Thanks much in advance.

Select columns based on another column value

Hi All,

I am working on a use case where I need to select some columns based on value of one of the column in row.

The sample example shown below:

Reference ID	Name	Indicator	Store1	Address1	Store2	Address2
ID1	A	1	StoreX	AddressX	StoreA	AddressX
ID2	B	1	StoreY	AddressY	StoreB	AddressY
ID3	C	2	StoreZ	AddressZ	StoreC	AddressZ

So, when the indicator is 1, I need to take forward columns Reference ID, Name, Store1 and Address1,

and when the indicator is 2, I need to take forward columns Reference ID, Name, Store2 and Address2.

Then I have big business logic to work on these columns.

Is there any simple way to achieve this? Thanks much in advance.

Workflow

Accepted answers

grossal

Hi @rachana19,

here is a quick way to do this:

Result:

Workflow attached. Let me know what you think.

Best

Alex

2020-04-27-Select columns based on another column value.yxmd

DavidP

I would use a filter tool to split the data to 2 different streams based on the value of [Indicator], then use a Select tool to select the correct fields for each stream.

You can recombine the streams with a Union Tool, but would have to rename the different fields in each select tool.

All comments

grossal

Hi @rachana19,

here is a quick way to do this:

Result:

Workflow attached. Let me know what you think.

Best

Alex

2020-04-27-Select columns based on another column value.yxmd

DavidP

I would use a filter tool to split the data to 2 different streams based on the value of [Indicator], then use a Select tool to select the correct fields for each stream.

You can recombine the streams with a Union Tool, but would have to rename the different fields in each select tool.

rachana19

Hi Alex,

Thanks a lot for this. This works as expected.

rachana19

Hi David,

Thanks a lot for this. This works as expected.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703