JSONを読み込む

Alteryx Designerでは、24.1以降、データ入力ツールを使用して、構造化された形式でJSONを読み取ったり解析したりできるようになりました。現時点では、AMP Engineはネストされたオブジェクトの最上位レベルを1つだけサポートします。

[
    {
        "business_id": "vcNAWiLM4dR7D2nwwJ7nCA",
        "open": true,
        "review_count": 9,
        "hours": {
            "Tuesday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Friday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Monday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Wednesday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Thursday": {
                "close": "17:00",
                "open": "08:00"
            }
        },
        "stars": 3.5
    },
    {
        "business_id": "UsFtqoBl7naz8AVUBZMjQQ",
        "open": true,
        "review_count": 4,
        "hours": {
            "Monday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Tuesday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Friday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Wednesday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Thursday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Sunday": {
                "close": "18:00",
                "open": "11:00"
            },
            "Saturday": {
                "close": "21:00",
                "open": "10:00"
            }
        },
        "stars": 3.5
    },
    {
        "business_id": "cE27W9VPgO88Qxe4ol6y_g",
        "open": false,
        "review_count": 5,
        "stars": 2.5
    }
]