Skip to content

Instantly share code, notes, and snippets.

@johntbush
Last active December 29, 2016 15:36
Show Gist options
  • Save johntbush/3a182a8258d6d402beef45aa62b147f4 to your computer and use it in GitHub Desktop.
Save johntbush/3a182a8258d6d402beef45aa62b147f4 to your computer and use it in GitHub Desktop.
{
"concept" : "bill weight qualifier",
"description" : "normalize the FB_WT_QUAL field that is part of the FRGHT_BL ",
"rules" : [
{
"field" : "AL_CNTRY_CODE_ORIG",
"rules" : [
{
"type":"expr",
"expression" :"AL_CNTRY_CODE_ORIG IN ('US','USA','UNITED STATES')",
"value":"US"
}
]
},
{
"field" : "FB_WT_QUAL",
"depends" : ["AL_CNTRY_CODE_ORIG"],
"rules" : [
{
"type":"expr",
"expression" :"feed_type = 'EDI' and FB_WT_QUAL = 'L'",
"value":"KG"
},
{
"type":"expr",
"expression" :"Feed_Type = 'EDI' and FB_WT_QUAL = '$$' and AL_CNTRY_CODE_ORIG = 'US'",
"value":"LB"
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment