Need final row as only single value for a group

Hey,

I am looking for something like this in the final field. Please look.

Thanks,

Aakash

Datasets

Data Investigation

Accepted answers

Yoshiro_Fujimori

Hi @Akash__on ,

If you want to set the "Response" to the new field only at the first line of a group of [Name], here is one way.

Workflow

Multi-Row Formula

IF IsEmpty([Row-1:Name]) THEN [Response]
ELSE Null()
ENDIF

Output

Does it work for your case?

MultiRow_Group.yxmd

All comments

Yoshiro_Fujimori

Hi @Akash__on ,

If you want to set the "Response" to the new field only at the first line of a group of [Name], here is one way.

Workflow

Multi-Row Formula

IF IsEmpty([Row-1:Name]) THEN [Response]
ELSE Null()
ENDIF

Output

Does it work for your case?

MultiRow_Group.yxmd

One way is to:

One Value Example.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703