Hi I'm trying to join data from same index but with different marker field and multiple values in second index. Example of rows: TS=06/22/2021 08:50:39:390|Type=A|Ids=550 TS=06/22/2021 08:51:39:390|Type=B|Ids=495,550,698 What I want is merge record Type=A with Record Type=B and get how much time passed (so TS from TypeB - TS from TypeA). Basically records with Type=A will always have one Ids, and with Type=B can have 1 or more Ids. Any ideas what could be the best? selfjoin in this case is not possible as the Type=B is multivalve field .
... View more