{
  "columnsSelection": {
    "mode": "ALL"
  },
  "explorationSampling": {
    "_refreshTrigger": 0,
    "selection": {
      "filter": {
        "distinct": false,
        "enabled": false
      },
      "latestPartitionsN": 1,
      "maxRecords": 10000,
      "maxRecordsForDisplay": -1,
      "ordering": {
        "rules": [],
        "enabled": false
      },
      "withinFirstN": -1,
      "partitionSelectionMethod": "ALL",
      "maxStoredBytes": 104857600,
      "targetRatio": 0.02,
      "maxReadUncompressedBytes": -1,
      "samplingMethod": "HEAD_SEQUENTIAL",
      "timeout": -1
    },
    "autoRefreshSample": false
  },
  "explorationFilters": [],
  "columnUseScientificNotationByName": {},
  "origin": "PREPARE_RECIPE",
  "exploreUIParams": {
    "autoRefresh": true
  },
  "steps": [
    {
      "preview": false,
      "mainColor": "#ff9c00",
      "name": "Date formatting",
      "metaType": "GROUP",
      "disabled": false,
      "comment": "Parse dates, extract date components from purchase_date, and compute days_active.",
      "steps": [
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateParser",
          "params": {
            "outCol": "",
            "formats": [
              "yyyy-MM"
            ],
            "columns": [
              "card_first_active_month"
            ],
            "timezone_id": "UTC",
            "appliesTo": "SINGLE_COLUMN",
            "lang": "auto"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateParser",
          "params": {
            "outCol": "purchase_date_parsed",
            "formats": [
              "yyyy-MM-dd HH:mm:ss"
            ],
            "columns": [
              "purchase_date"
            ],
            "timezone_id": "UTC",
            "appliesTo": "SINGLE_COLUMN",
            "lang": "auto"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateComponentsExtractor",
          "params": {
            "outMonthColumn": "purchase_month",
            "outHourColumn": "purchase_hour",
            "outYearColumn": "purchase_year",
            "column": "purchase_date_parsed",
            "outDayOfWeekColumn": "purchase_dow",
            "timezone_id": "UTC",
            "outDayColumn": "purchase_day"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "DateDifference",
          "params": {
            "output": "days_active",
            "input2": "purchase_date_parsed",
            "outputUnit": "DAYS",
            "input1": "card_first_active_month",
            "compareTo": "COLUMN",
            "reverse": false
          },
          "alwaysShowComment": false
        }
      ],
      "alwaysShowComment": true,
      "secondaryColor": "#f4e0c1"
    },
    {
      "preview": false,
      "name": "Geographical handling",
      "metaType": "GROUP",
      "disabled": false,
      "steps": [
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "GeoPointCreator",
          "params": {
            "out_column": "card_geopoint",
            "lat_column": "card_latitude",
            "lon_column": "card_longitude"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "GeoPointCreator",
          "params": {
            "out_column": "merchant_geopoint",
            "lat_column": "merchant_latitude",
            "lon_column": "merchant_longitude"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "GeoDistanceProcessor",
          "params": {
            "output": "dist_cardholder_merchant",
            "input2": "merchant_geopoint",
            "outputUnit": "MILES",
            "input1": "card_geopoint",
            "compareTo": "COLUMN"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "CityLevelReverseGeocoder",
          "params": {
            "doOutputBoundaries": false,
            "l4OutCol": "card_state",
            "inputCol": "card_geopoint"
          },
          "alwaysShowComment": false
        },
        {
          "preview": false,
          "metaType": "PROCESSOR",
          "disabled": false,
          "type": "CityLevelReverseGeocoder",
          "params": {
            "doOutputBoundaries": false,
            "l4OutCol": "merchant_state",
            "inputCol": "merchant_geopoint"
          },
          "alwaysShowComment": false
        }
      ],
      "alwaysShowComment": false
    },
    {
      "preview": false,
      "metaType": "PROCESSOR",
      "disabled": false,
      "type": "VisualIfRule",
      "params": {
        "legacyPositioning": true,
        "visualIfDesc": {
          "elseIfThens": [
            {
              "filter": {
                "uiData": {
                  "mode": "\u0026\u0026",
                  "conditions": [
                    {
                      "input": "days_active",
                      "col": "authorized_flag",
                      "num": 100.0,
                      "operator": "\u003c  [number]"
                    },
                    {
                      "input": "signature_provided",
                      "col": "authorized_flag",
                      "num": 0.0,
                      "operator": "\u003d\u003d [number]"
                    }
                  ]
                },
                "distinct": true,
                "enabled": true
              },
              "actions": [
                {
                  "outputColumnName": "risk",
                  "column": "transaction_id",
                  "formula": "",
                  "value": "medium",
                  "operator": "ASSIGN_VALUE"
                }
              ]
            }
          ],
          "elseActions": [
            {
              "outputColumnName": "risk",
              "column": "transaction_id",
              "formula": "",
              "value": "low",
              "operator": "ASSIGN_VALUE"
            }
          ],
          "ifThen": {
            "filter": {
              "uiData": {
                "mode": "\u0026\u0026",
                "conditions": [
                  {
                    "input": "days_active",
                    "col": "authorized_flag",
                    "num": 30.0,
                    "operator": "\u003c  [number]"
                  },
                  {
                    "input": "signature_provided",
                    "col": "authorized_flag",
                    "num": 0.0,
                    "operator": "\u003d\u003d [number]"
                  }
                ]
              },
              "distinct": true,
              "enabled": true
            },
            "actions": [
              {
                "outputColumnName": "risk",
                "column": "transaction_id",
                "formula": "",
                "value": "high",
                "operator": "ASSIGN_VALUE"
              }
            ]
          }
        }
      },
      "alwaysShowComment": false
    },
    {
      "preview": false,
      "metaType": "PROCESSOR",
      "disabled": false,
      "type": "SwitchCase",
      "params": {
        "mapping": [
          {
            "from": "internet",
            "to": "essential"
          },
          {
            "from": "gas",
            "to": "essential"
          },
          {
            "from": "luxury goods",
            "to": "discretionary"
          },
          {
            "from": "consumer electronics",
            "to": "discretionary"
          }
        ],
        "outputColumn": "spending_type",
        "normalization": "EXACT",
        "defaultValue": "",
        "inputColumn": "merchant_subsector_description"
      },
      "alwaysShowComment": false
    }
  ],
  "maxProcessedMemTableBytes": -1,
  "previewMode": "ALL_ROWS",
  "vizSampling": {
    "_refreshTrigger": 0,
    "selection": {
      "useMemTable": false,
      "filter": {
        "distinct": false,
        "enabled": false
      },
      "latestPartitionsN": 1,
      "maxRecords": -1,
      "ordering": {
        "rules": [],
        "enabled": false
      },
      "withinFirstN": -1,
      "partitionSelectionMethod": "ALL",
      "targetRatio": 0.02,
      "maxReadUncompressedBytes": -1,
      "samplingMethod": "FULL"
    },
    "autoRefreshSample": false
  },
  "analysisColumnData": {},
  "columnWidthsByName": {
    "date": 100,
    "merchant_latitude": 143,
    "spending_type": 113,
    "latitude": 134,
    "purchase_day": 105,
    "purchase_month": 120,
    "card_fico_score": 128,
    "merchant_id": 127,
    "reward_program": 155,
    "first_active_month": 150,
    "card_longitude": 120,
    "item_category": 113,
    "subsector_description": 173,
    "dist_cardholder_merchant": 195,
    "merchant_state_enName": 173,
    "purchase_date_parsed": 190,
    "card_state": 100,
    "internal_card_mapping": 197,
    "card_state_enName": 143,
    "signature_provided": 150,
    "purchase_dow": 105,
    "card_age": 100,
    "fico_score": 100,
    "longitude": 134,
    "transaction_id": 120,
    "purchase_year": 113,
    "card_first_active_month": 188,
    "days_active": 100,
    "card_latitude": 113,
    "merchant_category_id": 165,
    "card_id": 120,
    "merchant_longitude": 150,
    "merchant_subsector_description": 240,
    "purchase_hour": 113,
    "card_geopoint": 113,
    "purchase_amount": 134,
    "merchant_state": 120,
    "card_reward_program": 158,
    "merchant_geopoint": 143,
    "risk": 100,
    "purchase_date": 148,
    "authorized_flag": 128,
    "age": 100
  },
  "sorting": [],
  "globalSearchQuery": "",
  "coloring": {
    "scheme": "MEANING_AND_STATUS",
    "individualColumns": [],
    "valueColoringMode": "HASH"
  }
}