How can I Split this scenario?
Contributor II
in Help
KEY VALUE
TYPE+DIR CUST+I
TYPE+DIR CUST+O
want output
TYPE DIR
CUST I
CUST O
0
Answers
I've attached some extended set demo process that combines multiple Types, Dirs and Customers as I assume this is probably more what you aim for. I also took for granted there is a + sign, so you may need to tweak this a bit. Just hope this gets you started in the right direction.