Join by Multiple Fields (FirstName & LastName)
1
2013-09-06
2
2014-01-26
5
2012-05-05
31
2014-12-21
49
2014-08-21
49
2014-08-12
File B: ID and FirstPurchaseDate
Join by Record Position
Thomas
Edison
2014-08-21
Galileo
2014-04-01
Benjamin
Franklin
2014-12-21
Dorothy
Gerber
2012-05-05
Louis
Pasteur
2013-09-06
Tim
Berners-Lee
2014-01-26
File C: Name and FirstPurchaseDate
Join by Single Field (CustomerID)
Warning
All
ByName
C:\Users\Matthew Curtis\Documents\Alteryx\Temp Folder\Engine_14100_4121a201a1a24755b88bc4e75b8587f4_\Engine_2428_4a9ede3817994673b448aab7c6c5a8ed_.yxdb
Single
Profile
49
Thomas
Edison
M
2014-08-21
456
Galileo
M
2014-04-01
31
Benjamin
Franklin
M
2014-12-21
5
Dorothy
Gerber
F
2014-10-01
1
Louis
Pasteur
M
2013-09-06
2
Tim
Berners-Lee
M
2014-01-26
File A: Core Customer Data
Filter
isempty([LastName]) or isnull([LastName])
Warning
High
False
"Looks like there's null values in the LastName field."
Test Container
Unmatched Records from Customer Data
#1
RecCountValue
0
Unmatched Records from Customer Data
Duplicate Records in Join by Single Field
#2
RecCountMatch
#1
Duplicate Records in Join by Single Field
Horizontal
Testing Examples 1