Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Full outer join data

poojitha4
8 - Asteroid

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:

topicIdsmetricSeries
798415TotalBuzz
798415NetSentiment
798415Passion
800755TotalBuzz
800755NetSentiment
800755Passion
801765TotalBuzz
801765NetSentiment
801765Passion
801781TotalBuzz
801781NetSentiment
801781Passion
801811TotalBuzz
801811NetSentiment
801811Passion


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.

2 REPLIES 2
MSalvage
11 - Bolide

@poojitha4,

 

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

 

Best,

MSalvage

poojitha4
8 - Asteroid

Thanks, I solved it using the R tool!

Labels