Full outer join data

Question

Hi ,

I have two inputs data like:

metricSeriesTotalBuzzNetSentimentPassion

topicIds798415800755801765801781801811801825801965801973801983801995816205816207816211816281816285816289816297

For every topic id I need all the three metricSeries like:

topicIdsmetricSeries798415TotalBuzz798415NetSentiment798415Passion800755TotalBuzz800755NetSentiment800755Passion801765TotalBuzz801765NetSentiment801765Passion801781TotalBuzz801781NetSentiment801781Passion801811TotalBuzz801811NetSentiment801811Passion

I'm not sure if this is even a full outer join scenario but I need data thatw ay. Any help will be appreciated.

Thank you.

MSalvage · Accepted Answer

@poojitha4,

You can just use the append fields tool with topicIds as your target and MetricSeries as your source. Sample attached.

Best,

MSalvage