Hello, I have some issues on presenting certain data from a file in a specific way.I have two columns in my file that look like columns A and B. Based on column B, I would like column A to state specific data as the example below. Please consider that my data comprise of multiple rows. Column A (as is now) Column B(as is now) Column C (as I want it to be) ALL SUBTYPES - ALL SUBTYPES ALL SUBTYPES APPLE KIWI ALL SUBTYPES - ALL SUBTYPES ALL SUBTYPES - ALL SUBTYPES ALL SUBTYPES APPLE-NEGATIVE KIWI ALL SUBTYPES - ALL SUBTYPES ALL SUBTYPES ONE BANANA KIWI ORANGE ORANGE ORANGE PINEAPPLE PINEAPPLE PINEAPPLE Thank you!

creating new column and presenting data from 2 different columns

Hello, I have some issues on presenting certain data from a file in a specific way.I have two columns in my file that look like columns A and B. Based on column B, I would like column A to state specific data as the example below. Please consider that my data comprise of multiple rows.

Column A (as is now)	Column B(as is now)	Column C (as I want it to be)
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE-NEGATIVE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	ONE BANANA	KIWI
ORANGE	ORANGE	ORANGE
PINEAPPLE	PINEAPPLE	PINEAPPLE

Thank you!

Datasets

Developer Tools

Dynamic Processing

Database Connection

Accepted answers

jeff_reynolds

Hi. See attached workflow. It uses Fernando's formula, with an extra step to add in your updated logic.

updated_logic.yxmd

All comments

fmvizcaino

Hi @arieta ,

You can use an IF function to present the data as you need.

IF IsNull([Column B(as is now)]) or [Column A (as is now)]=[Column B(as is now)]
then [Column A (as is now)]
else 'Kiwi'
endif

Best,

Fernando Vizcaino

2020-05-29 creating new column and presenting data from 2 different columns.yxmd

arieta

Hi @fmvizcaino,

Thanks a lot for the reply! It worked this way, however, just understood that I presented my data a bit differently than they actually are. Please see below a more accurate example:

Column A (as is now)	Column B(as is now)	Column C (as I want it to be)
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	APPLE-NEGATIVE	KIWI
ALL SUBTYPES	-	ALL SUBTYPES
ALL SUBTYPES	ONE BANANA	KIWI
TRIPLE-NEGATIVE	CHERRY	TRIPLE NEGATIVE
TRIPLE NEGATIVE	WATERMELON	TRIPLE NEGATIVE
ORANGE	ORANGE	ORANGE

Mainly the change is the bold rows. So, when 'triple-negative' is presented in Column A, I would like to also exist in Column C. Could you please help me with this?

Thank you!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167