Null Error while applying Union

aashutosh

Hello All,

I have 2 tables  one field is unique and 2 have different values. Now I need to merge them hence using union, while it generating the output , one table is giving Null value however value is there when looking at the input table.

Example below

Input

Table 1

Book  PV_Jam

ABS    10

ASN   10

ASM   15

Table 2

Book  PV_KAM

ABS    18

ASN   10

ASM   12

Output

Table 2

Book  PV_JAM  PV_KAM

ABS    10            Null

ASN   10             Null

ASM   12            Null

thanks for help !

DataNath

No problem at all @aashutosh - glad to see you getting into Alteryx!

If you look at my screenshot above, you'll see that all of the fields are listed in the bottom of the Join tool configuration. This is all of the fields that will come out of the join once you run your workflow and you can edit these in the exact same way you use a Select tool. You can untick fields so they're not present in the output and you can also change the data type, size and rename said fields. In the answer I provided above, you'll see that I just unticked the 'Right_Book' field so that it doesn't come out in the input. When you're using the join tool, there'll always be duplicate field(s) as they're the unique key that you conduct the join on - by default, the second dataset will always be renamed to Right_FieldName. One easy way to remove these duplicate fields is to use the following dropdown:

And the 'Right_Book' field is automatically taken care of:

Basically, the section highlighted in red acts the same as a Select tool, so you don't need to use Join > Select.