Creating a formula based on a column existing or not

Hi All,

I am quite new to this community, having an issue processing a report whose column might differ on every run. For example:

Col A	Col B	Col C
ABC	DEF	GHI

Sometimes all three columns exist, or sometimes only column B exists, etc.

I'd like to create a new column with the following logic:

IF (col A exists) THEN [col A]

ELSEIF (col B exists) THEN [col B]

ELSEIF (col C exists) THEN [col C]

ELSE null( )

ENDIF

For example, if only Col B & Col C exists, the value taken should be from Col B. How would this be possible? Thanks for your help!

Dynamic Processing

Accepted answers

Qiu

@nbryanrh
I think we need to "force" all the column to be present even when they are not. 😀

I created another input file which contains only all the columns then do a union/

0419-nbryanrh.yxmd

All comments

Qiu

@nbryanrh
I think we need to "force" all the column to be present even when they are not. 😀

I created another input file which contains only all the columns then do a union/

0419-nbryanrh.yxmd

Gandalf_NotGrey

Hello @Qiu I have a similar query.

Your solution works only when either all three are present or all three are not present.

If Col A and Col B are present and only Col C is not present, then this does not works, since the union will create a new row instead of adding a null field in the same row.

Can you please help me understand on what to do in such a scenario?

I have added a sample workflow for your reference.

Thanks.

New Workflow4.yxmd

Qiu

@Gandalf_NotGrey
There are 2 minor points you have missed out in your sample flow. Check below snaoshot with comment.

2025-05-27 200702.jpg 2025-05-27 200738.jpg

New Workflow4-r1.yxmd

Gandalf_NotGrey

Thanks @Qiu - Keeping the empty row was wrong, removing it made the workflow work.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335