Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Join Formula Issue

Highlighted
7 - Meteor

Hello Everyone,

 

I have 2 sets of information i want to join somehow for comparison reasons. These are:

 

1)

 
 
 
 
 
RowDescriptionBase Dataspec
76750     FOREIGN DIVIDENDSINPUT
  6043090  -1         FOREIGN CORPS.-100% SEC 245B                         W
  6043090  -1         FOREIGN CORPS.-100% SEC 245B                         E
  6043190  -1         FOR CORPS - 100% SEC 245 SUB TO                      W
  6043190  -1         FOR CORPS - 100% SEC 245 SUB TO                      E
  6043RT1  -1         FRGN CORP-100% SEC 245B-REPORT T                     W
  6043RT1  -1         FRGN CORP-100% SEC 245B-REPORT T                     E
  6042050  -1         FOREIGN CORPORATIONS - 65%                           W
  6042050  -1         FOREIGN CORPORATIONS - 65%                           E
  6042150  -1         FOR CORPS - 65% SUB TO 832                           W
  6042150  -1         FOR CORPS - 65% SUB TO 832                           E
  6042RT2  -1         MORE THAN 20% OWNED CFC-REPORT T                     W

 

 

2) 

RowDescriptionCustom Dataspec
76750     A. FOREIGN DIVIDENDSINPUT
  8207065  1          STATE ADJ FOR SEC 965 INCOME                         W
  6044     -1         FOREIGN CORPORATIONS-OTHER                           E
  6045     -1         FOREIGN CORPS.-SUBPART F(CONTROL                     E
  8ID2406  1          FOREIGN DIVIDENDS (WATER'S EDGE)                     E

 

 

The end result I'd need is

 
 
RowDescriptionCustom DataspecBase Dataspec
76750     FOREIGN DIVIDENDSINPUTINPUT
  8207065  1          STATE ADJ FOR SEC 965 INCOME                         W6043090  -1         FOREIGN CORPS.-100% SEC 245B                         W
  6044     -1         FOREIGN CORPORATIONS-OTHER                           E6043090  -1         FOREIGN CORPS.-100% SEC 245B                         E
  6045     -1         FOREIGN CORPS.-SUBPART F(CONTROL                     E6043190  -1         FOR CORPS - 100% SEC 245 SUB TO                      W
  8ID2406  1          FOREIGN DIVIDENDS (WATER'S EDGE)                     E6043190  -1         FOR CORPS - 100% SEC 245 SUB TO                      E
   6043RT1  -1         FRGN CORP-100% SEC 245B-REPORT T                     W
   6043RT1  -1         FRGN CORP-100% SEC 245B-REPORT T                     E
   6042050  -1         FOREIGN CORPORATIONS - 65%                           W
   6042050  -1         FOREIGN CORPORATIONS - 65%                           E
   6042150  -1         FOR CORPS - 65% SUB TO 832                           W
   6042150  -1         FOR CORPS - 65% SUB TO 832                           E
   6042RT2  -1         MORE THAN 20% OWNED CFC-REPORT T                     W
   6042RT2  -1         MORE THAN 20% OWNED CFC-REPORT T                     E
 
 
 
 

 

 

Problem: do you see that, for example row 76750 has much more values on the "Base Dataspec" Column in image n° 1  than in image n°2 ("Custom Dataspec" column)? 

 

I tried using a Join Formula but its not bringing the whole information. Can someone advice??

 

Thanks!

 

 

Highlighted
Alteryx
Alteryx

Do you just want these two columns next to each other?

 

You can use the join multiple tool with join by record position.

 

echuong1_0-1595352076610.png

 

Highlighted
7 - Meteor

Hi,

You can use Join (by record position)+ Union to get the entire list. Hope this helps!

 

CharuGupta_0-1595352431147.png

 

Labels