How to join metric data

[drezanka]

I have several types of metric data going into a metric index. One has 'username' and 'DimA' as dimensions, and 'ValueA' as the metric_name.
The second type of metric data has 'DimA' as its dimension and 'ValueB' as the metric_name.
I would like to associate the 'username' with 'ValueB'.

How can I accomplish this?

[somesoni2]

You should be able to run join after running mstats command like this
https://answers.splunk.com/answers/592935/using-mstats-to-create-separate-columns-per-metric-1.html

OR you can use append-stats alternative of join.