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!
Solved! Go to Solution.
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
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!