Given a list of key value pairs, like extracted metadata from html meta tags:
To move the values in colums the Row denormalizer step of PDI or Apache Hope can be used:
This will transpose the rows to colums:
I cases there are more values for one key, those values could also be aggregated, like “Concatenate string seperated by ,”