expedia priceline hotels.com hitwire
hotwire pinceline htels.com bookng.com
princeline hotwire expdia
Response Data
1
RecordID
Int32
0
Groups to survey number
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_b9a868fccc2d464faaeb323d2a17f81e_.yxdb
Response Data
Match
Response Data
Warn
Expedia Match
Expedia
Match:
exp[a-z]*d[a-z]*
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_e4f163e409ba41b3bd225415199d1ae9_.yxdb
Response Data
Match
Response Data
Warn
Hotwire Match
Hotwire
Match:
h[a-z]*tw[a-z]*r[a-z]*
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_d73915b1512742229ef1dec364d6a05a_.yxdb
Response Data
Match
Response Data
Warn
Priceline match
Priceline
Match:
pr[a-z]*l[a-z]*n[a-z]*
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_6e7064509b054d65b99170c9c29469c3_.yxdb
Error
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_ad1dd258e4664142a07d02dc852175f4_.yxdb
Sample for Soundex comparison
SoundexSurvey=Soundex([Response Data])
SoundexBrand=Soundex('Priceline')
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_3881845ec7c540b49265ba3fbc3914fc_.yxdb
[SoundexSurvey] = [SoundexBrand]
Custom
[SoundexSurvey] = [SoundexBrand]
C:\ProgramData\Alteryx\Engine\Engine_10288_b72150683cde4d708e0318ed363f17b6_\Engine_10488_aee9af20380e4ca784bec7989e09549e_.yxdb
Horizontal
RegEx example