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