How to split and store splited data in macro

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 5 in Community Q&A
Hello,
I have one Column "Parameter" that contains  values below
Parameter
Financial Product=REMITTANCE|MESSAGEDIRECTION=I

I want to store both in macro after split
like 
%{Key}   %{value}
%{key_1}  %{value_1}


Tagged:

Answers

  • hbajpai
    hbajpai New Altair Community Member
    Hey @sgnarkhede2016

    You can split and save them using extract macro. Can you elaborate where you are facing issues?
  • sgnarkhede2016
    sgnarkhede2016 New Altair Community Member
    As mentioned above I have one column that contain values "Financial Product=REMITTANCE|MESSAGEDIRECTION=I"
    I want to spit it first then store in macro dynamically means if in future instead of two key maybe three keys present then how to handle this like "Financial Product=REMITTANCE|MESSAGEDIRECTION=I|CUST_TYPE=NC" after storing i want to filtered it out by passinng macros

Categories