# Condition for Select Columns

**URL:** <https://community.parabola.io/t/condition-for-select-columns/2104>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [October 28, 2021, 10:11pm UTC](https://community.parabola.io/t/condition-for-select-columns/2104 "2021-10-28T22:11:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam\_Briones](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@Sam\_Briones](https://community.parabola.io/u/Sam_Briones)\
**Post date:** [October 28, 2021, 10:11pm UTC](https://community.parabola.io/t/condition-for-select-columns/2104/1 "2021-10-28T22:11:04Z")

</div>

Is there a way to Select Column based on a specific value existing in a row from a different column?  
For example:

- If column A contains “Hello World” Select Column A, B & C; Else Select Column A & B

---

<div class="post-metadata">

**Author:** ![Adam\_R](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/adam_r/32/2207_2.png) [@Adam\_R](https://community.parabola.io/u/Adam_R)\
**Post date:** [October 29, 2021, 3:05am UTC](https://community.parabola.io/t/condition-for-select-columns/2104/2 "2021-10-29T03:05:00Z")

</div>

Hey @Sam_Briones 👋

While there’s no clean-and-simple solution for this use case, I was able to mock out an example using your sample data. You can paste this example directly into your flow using the snippet at the bottom of the post.

 ![Screen Shot 2021-10-28 at 6.41.45 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/391d4e9e22ae69f65335a9f364dc99e0f63c019c.png)

1. **Input Data**

![Screen Shot 2021-10-28 at 6.42.15 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/100d98ef8fee58ef20363419a5eb1b2a5e5211fc.png)

1. **Insert Row Numbers** : This helps facilitate the table flip in the next step

![Screen Shot 2021-10-28 at 6.43.13 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/f5c93d042ddddd6fe19fc1908f7af5d3e0410585.png)

1. **Flip Table** : This enables us to apply if/else logic in the next step

![Screen Shot 2021-10-28 at 6.43.47 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/baa404811df9f31d0922aef818027795ce5c0ea0.png)

1. **Insert If/Else Column** : If the specific column of interest (based on the value in “Row Number”) contains the value of interest (ex. Hello World), then set the column value to ‘Yes’.

- If there is another column that should always be kept regardless of conditions (such as column B based on your example), set that value to ‘Yes’ as well

 ![Screen Shot 2021-10-28 at 7.51.56 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/41a41c239fe237ef3c75d819e1d757316f69fe01.png)

1. **Flip Table** :

![Screen Shot 2021-10-28 at 7.56.57 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/4723afdec1c5b702e3fd8a815cd796b9e9212164.png)

1. **Rename Column** : Here, you want to modify the name of the column that should be conditionally included

![Screen Shot 2021-10-28 at 7.57.45 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/a/aacd22873735f92ee0e361140f82ee3b3ed34068.png)

1. **If/Else** : Here, we recreate your conditional column. If your column of interest has the value ‘Yes’ in the ‘Meet Criteria?’ row, it will put a ‘Yes’ in the column. We also say ‘If C1 is not blank, set the new column value to C1’ so that the new column retains the values from your original column.

 ![Screen Shot 2021-10-28 at 7.58.11 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/4994490c74090a0cdf66a8bc020639b9b207a099.png)

1. **Flip Table**

![Screen Shot 2021-10-28 at 8.01.17 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/f5bf26488bb60bef1ddb89720cf08fc01978fe47.png)

1. **Filter Rows**

 ![Screen Shot 2021-10-28 at 8.01.59 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/6/69526e1b0d80898e8fbda94ee27aa87a1d1a47fa.png)

1. **Flip Tables** : with that, the use case is complete!

![Screen Shot 2021-10-28 at 8.02.37 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/f4a5b855f27ef3f498d2fd585284757fc4ffb435.png)

Definitely realize that this isn’t the simplest workaround, but unfortunately this is a tricky Parabola use case! If you’d like to paste these steps directly into your flow, feel free to paste this snippet into your flow: `parabola:cb:aef34464960b4e03b1b38fff2489917a`

Let me know if you have any questions and how it works out!