What's the best way to do an if statement for status codes?

Logan Carter

What's the best way to do an if statement for status codes. Like is status=400, a new field is made statusCode = "Bad Request"

Jon Rust

If a one off, use something like this in an eval statusCode = `status == '400' ? "Bad Request" : statusCode`

Jon Rust

you could have a series of those

Logan Carter

I was thinking maybe a lookup too, since status codes are pretty much static

Jon Rust

Better, more scalable solution IMO is to use a lookup file (under processing, knowledge) statusCode = `C.Lookup('filename.csv','code').match(status,"return_field")`

Jon Rust

you can also use the built-in Lookup function

Jon Rust

AND mind the type of field status is! Is it a number or a string? You'll need to match the type

Logan Carter

Good point, I'll be sure to check on that

asc_me

lookup is far easier to maintain than the series of if/or statements.