Keyword lookup
Description
Split description into rows for each word
Split description into rows for each word
Create flag column for keywords
Description
Key Words
Key Words
FindWhole
Append
Find/Replace and append the flag when keyword is found
Find/Replace and append the flag when keyword is found
Data prep - split data and keywords into separate streams
C:\Users\bbak\OneDrive - alteryx.com\Desktop\Alteryx Example.xlsx|||`Sheet1$`
False
1
Alteryx Example.xlsx
Query=`Sheet1$`
Simple
IsNotNull
Part #
True
fixed
2022-11-28 08:27:06
0
2022-11-28 08:27:06
2022-11-28 08:27:06
!IsNull([Part #])
Combine with original data
Join back on original data
Join back on original data
Ignore
All
ByName
Union J and L to include descriptions without keyword matches
Union J and L to include descriptions without keyword matches
C:\ProgramData\Alteryx\Engine\Engine_39108_a599e843e5242d458646e47b1e3e56a9_\Engine_39108_511cda58d620e54f9227f4da0d254388~.yxdb
Single
Profile
Result
Result
Data formatting
Simple
IsNotNull
Flag
True
fixed
2022-11-28 08:28:56
0
2022-11-28 08:28:56
2022-11-28 08:28:56
Filter out null flags
!IsNull([Flag])
Running total on flags and group by part number
Running total on flags and group by part number
,
Crosstab back into table
Crosstab back into table
Horizontal
Keyword lookup