Multi Row expression

[AnGi]

Need help with correct expression: i have an input data file with 2 fields like shown bottom. I want for Field A to have only the first unique value and blank the other same value. Help

Field A     Field B

A               10

A               15
B               8

B                5

B               23

C               6

D                4

D              21

D             14

[ChrisTX · Accepted solution]

This formula should work.

IF IsEmpty([Row-1:Field A]) THEN [Field B]
ELSE Null()
ENDIF

When you select the Group By option, the row before the first row in each group is defined as empty values.

So I just used a formula with "IsEmpty (row - 1)", with the Group By option selected.

Chris

[LordNeilLord · Accepted solution]

Hey @AnGi 

Do you mean like this?