Hello amazing community! I'm now stuck with a problem that most probably has a really simple solution 🙂  I have a table that is generated every night with a batch process, I would need to merge the "today" table with the "yesterday" table and see what is different. This is an example just to keep things easy: Yesterday table: A Old B Old C Old D Old E Old Z Old   Today Table: A New B New C New D New E New F New   Expected result: A Old New B Old New C Old New D Old New E Old New Z Old null F null New   Any idea about how I can achieve this? Many thanks in advance ... View more

Hello community! For a project I'm working on, I would need to split a "multivalues single event" into "multiple single value events". Let me try to represent it for clarity: As is: Event: A B C null D E F G H I L Desired: Event1: A B C null D Event2: A B E F G Event3: A B H I L  Is it possible to achieve this?  I played around with mvexpand and mvzip but I wasn't able to reach my goal. Thanks in advance for your kind support ... View more