How can I Split this scenario?

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
KEY        VALUE
TYPE+DIR   CUST+I
TYPE+DIR   CUST+O

want output
TYPE  DIR
CUST  I
CUST  O

Answers

  • kaymankayman Member Posts: 662 Unicorn
    I guess you need to combine splits and value loops, but your dataset is pretty small to draw conclusions :wink:
    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.
Sign In or Register to comment.