How to split and store splited data in macro

sgnarkhede2016

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}

hbajpai

Hey @sgnarkhede2016

You can split and save them using extract macro. Can you elaborate where you are facing issues?

sgnarkhede2016

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