Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I would like to ask you to find very quick and clean solution to populate column InteractionCycleID in script as shown based on Interaction column.
Thank you.
BR
Martin
Ok.
I have found solution using intervalmatch with applymap(ID&ValidFrom&ValidTo,ID,null()) to original table.
create a new expression
max(total <ID> Interaction)
Regards
Hi Martin,
thank you. As mentioned above, I need that operation to be done in script, not by table object in GUI.
BR
M
so in script:
left join (tablename)
load
ID,
max(Interaction) as IDInteraction
resident table
group by ID;
Hi Martin,
thank you for an answer. Unfortunately your solution does not help as ID contains potentially more than one Interaction.
BR
Martin
Ok.
I have found solution using intervalmatch with applymap(ID&ValidFrom&ValidTo,ID,null()) to original table.