AnsweredAssumed Answered

Popoulate fields based on occurrences and text

Question asked by CCweedcontrol on Oct 15, 2020
Latest reply on Oct 16, 2020 by 2CQuiker

Trying to figure out how to populate two fields based on two fields. I need to be able to populate say F_ID3 with the number of occurrences of F_ID1 then in F_D4 add the text of the occurrences from F_ID2. Like below, note that their may be empty or nulls in the fields

 

 

Currently have this

OBJECTIDF_ID1F_ID2
1aa112312345
2aa112312346
3BB336167891
4BB336167892
5BB336167893
6UU983211123
7PP22256989
8PP22256988

 

I need this

OBJECTIDF_ID1F_ID2F_ID3F_ID4
1aa112312345212345, 12346
2aa112312346  
3BB336167891367891, 67892, 37893
4BB336167892  
5BB336167893  
6UU983211123111123
7PP2225698926988, 6989
8PP22256988  

Outcomes