Multi-Row Formula

Question

Hi All,

I am trying to form of Group ID based on similar records of a field below ECM_Party_ID. Just because it has "Nulls" in between it is forming a new group ID. I want my result to be in below format.

I have attached the formula, pls help me achieve the below output. Thanks in Advance.

Record_IDECM_PARTY_IDNew_Group_IDColumnn C should be196812147719681214771 871968121497196812149719681214971 107196812141171968121411719681214117196812141171 127196812141371968121413719681214137196812141371968121413719681214137196812141371968121413719681214137298301131482983011314836257890159362578901594979971316104979971316104 1710497997131710

Multi-Eow formula.yxmd

binu_acs · Answer

@Sarath27 One way of doing this

Multi-Eow formula.yxmd

DataNath · Answer

Would something like this not work? Basically use an initial Multi-Row Formula to fill in the blanks and then assign the progressive ID, before removing the temporary 'filler' field to arrive at the desired format:

Progressive IDs ignoring nulls.yxmd

IraWatt · Answer

Hey @Sarath27,

Here is one way to get round this. You can filter off the NULL rows and re-join after the formula and finally sort to get the initial ordering:

Not sure why your New_Group_ID starts at 7?

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd