I want to join these different product_id's from an XML file into one table:
<product_detail>
<product_id>1003C</product_id>
<product_detail>
<product_id>1002C</product_id>
</product_detail>
Example: 1003C,1002C
I've tried split, mvjoin, spath, and nothing works. Here's sample of my query:
source=xxxxxx.log
| xmlkv
| spath input=product_id
| table product_id
| eval product_id=split(product_id,";")
| eval product_id=mvjoin(product_id,";")
How do I get the output of these multiple values into a semi-colon?
... View more