How to merge value from multiple fields into a single field (Field = Value format)?

[tehong]

Hi. 

I want to merge data from multiple fields into a single field.

If you have a table like the following

fieldA, fieldB, fieldC
------------------------------
valueA, valueB, valueC

The expected output is as follows. I want to combine them into a single field in the Field = Value format.

merge_data = "fieldA = valueA, fieldB = valueB, fieldC = valueC"

I think it can be done using multivalue OR foreach, but I don't know how to code it.

Thanks in advance!!

[tehong]

Thanks perfect!!

[ITWhisperer · Accepted solution]

| eval merge_data=","
| foreach field*
    [| eval merge_data=merge_data."<<FIELD>>"."=\"".trim(<<FIELD>>)."\","]
| eval merge_data=trim(merge_data,",")