Use an IF to identify and Credit Card BIN numbers.

Hello @TigerCole,

can’t you just use one Rule Engine node with multiple rules and appropriate outcome for each?

cardNumber LIKE “4*” => “VISA”
cardNumber LIKE “2221*” OR cardNumber LIKE “2720*”=> “MASTERCARD”

Should be much faster but still will require some time to process 70 million rows…

Br,
Ivan

1 Like