The "append fields" with unique id

chuntingsimonlo

I am studying my teammate alteryx program, there have two tables
one is look like this:

id	amount	count
1	123	1
2	567	1
2	321	1

and he just selected the unique id, then the table become like this:

id

1

2

and one is look like this:

count	viollation
2	Y
2	N

After he use the "append fields" to combine two table, the output should be like this right:

id	count	viollation
1	2	Y
1	2	N
2	2	Y
2	2	N

But don't know why, the output is look like this: 

id	count	viollation
1	2	Y
1	2	N

Can anyone tell me whats going on? Thanks.

ShankerV

Hi @chuntingsimonlo 

Post the Count Records tool, the formula tool with IF condition stores only value Y or N.

Consider the IF returns the value Y.

So the value passed to Append Fields is 

count	viollation
2	Y

or 

count	viollation
0	N

The same then is being append with the output from the Unique tool. 

Consider the Unique tool give the output.

id

1

2

So these both gets append.

Many thanks

Shanker V