Full outer join data

[poojitha4]

Hi ,

I have two inputs data like:

metricSeries

TotalBuzz

NetSentiment

Passion

topicIds
798415
800755
801765
801781
801811
801825
801965
801973
801983
801995
816205
816207
816211
816281
816285
816289
816297

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

topicIds	metricSeries
798415	TotalBuzz
798415	NetSentiment
798415	Passion
800755	TotalBuzz
800755	NetSentiment
800755	Passion
801765	TotalBuzz
801765	NetSentiment
801765	Passion
801781	TotalBuzz
801781	NetSentiment
801781	Passion
801811	TotalBuzz
801811	NetSentiment
801811	Passion

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 solution]

@poojitha4,

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

Best,

MSalvage

[poojitha4]

Thanks, I solved it using the R tool!