財務データを含むテストデータセットの作成 - Cloud

Talend Cloud Pipeline Designer入門ガイド

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
ジョブデザインと開発 > パイプラインのデザイン
デプロイメント > デプロイ中 > パイプラインの実行
EnrichPlatform
Talend Pipeline Designer
Talend Pipeline Designerを使用すると、手動で入力したスキーマに基づいてデータセットを作成できます。

手順

  1. [ADD A NEW DATASET] (新しいデータセットの追加)パネルで、テストデータセットにfinancial dataというような名前を付け、データを追加する接続として[test connection] (テスト接続)(以前に作成済み)を選択します。
  2. 必要に応じて説明を追加し、データの形式を選択します: この場合、JSONを選択します。
  3. [Values] (値)エリアで、以下のサンプルデータをコピーして貼り付けます。
    {
      "transaction": {
        "id": "0",
        "this_account": {
          "id": "1001",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB76LFZB49988909369549"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB96YKDK59692689157588"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-28T04:23:33.000Z",
          "completed": "2018-03-18T12:23:17.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 71
          },
          "value": {
            "currency": "EUR",
            "amount": 81
          }
        }
      }
    }
    {
      "transaction": {
        "id": "1",
        "this_account": {
          "id": "1002",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR8513439527444624681766695"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR8077386641683499174588483"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-07T13:42:55.000Z",
          "completed": "2018-03-04T17:59:04.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 63
          }
        }
      }
    }
    {
      "transaction": {
        "id": "2",
        "this_account": {
          "id": "1003",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "op.02.fi"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6476661028523953"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6889853185824999"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-27T07:42:12.000Z",
          "completed": "2018-03-22T16:01:10.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 50
          }
        }
      }
    }
    {
      "transaction": {
        "id": "3",
        "this_account": {
          "id": "1004",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB05UKDA71695820095764"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB65NPZK15493976545773"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-03T14:17:09.000Z",
          "completed": "2018-03-14T21:55:15.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 99
          },
          "value": {
            "currency": "EUR",
            "amount": 16
          }
        }
      }
    }
    {
      "transaction": {
        "id": "4",
        "this_account": {
          "id": "1005",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.de"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0044 0532 0130 00"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0044 0532 0130 00"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-15T04:53:13.000Z",
          "completed": "2018-03-23T05:13:38.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 62
          },
          "value": {
            "currency": "EUR",
            "amount": 80
          }
        }
      }
    }
    {
      "transaction": {
        "id": "5",
        "this_account": {
          "id": "1006",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.de"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0045 0532 0130 00"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "DE89 3704 0045 0532 0130 00"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-25T13:35:34.000Z",
          "completed": "2018-03-20T11:23:21.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 100
          },
          "value": {
            "currency": "EUR",
            "amount": 67
          }
        }
      }
    }
    {
      "transaction": {
        "id": "6",
        "this_account": {
          "id": "1007",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR5537581636921195789485931"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR4432812773642019978325014"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-09T07:40:25.000Z",
          "completed": "2018-03-05T18:35:20.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 81
          },
          "value": {
            "currency": "EUR",
            "amount": 26
          }
        }
      }
    }
    {
      "transaction": {
        "id": "7",
        "this_account": {
          "id": "1008",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.fr"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR0927793667926055290687622"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FR4977447561846755098777662"
          }
        },
        "details": {
          "type": "DC",
          "description": "OBP",
          "posted": "2018-03-06T09:10:02.000Z",
          "completed": "2018-03-24T07:48:36.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 30
          },
          "value": {
            "currency": "EUR",
            "amount": 20
          }
        }
      }
    }
    {
      "transaction": {
        "id": "8",
        "this_account": {
          "id": "1009",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB45NAAG13514531088144"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "GB08GPQI02436060300396"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-13T06:47:43.000Z",
          "completed": "2018-03-19T17:08:47.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 29
          },
          "value": {
            "currency": "EUR",
            "amount": 45
          }
        }
      }
    }
    {
      "transaction": {
        "id": "9",
        "this_account": {
          "id": "1010",
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "op.02.fi"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI6104157151295139"
          },
          "holders": [
            {
              "name": "OBP",
              "is_alias": true
            }
          ]
        },
        "other_account": {
          "id": "String",
          "holder": {
            "name": "OBP",
            "is_alias": true
          },
          "bank_routing": {
            "bscheme": "Bank_ID",
            "address": "gh.29.uk"
          },
          "account_routing": {
            "ascheme": "IBAN",
            "address": "FI9149180342136836"
          }
        },
        "details": {
          "type": "AC",
          "description": "OBP",
          "posted": "2018-03-25T08:01:19.000Z",
          "completed": "2018-03-15T05:18:25.000Z",
          "new_balance": {
            "currency": "EUR",
            "amount": 37
          },
          "value": {
            "currency": "EUR",
            "amount": 85
          }
        }
      }
    }
    注: サンプルのサイズは32KBを超えることはできません。
  4. [VIEW SAMPLE] (サンプルの表示)をクリックして、プレビューが可能です。
  5. [VALIDATE] (検証)をクリックしてデータセットを保存します。

タスクの結果

[DATASETS] (データセット)ページで、新しいデータセットがリストに追加され、パイプラインで使用できるようになります。

プレビューするには、データセットリストの名前をクリックします。データセットビューにリダイレクトされ、データが有効であることを確認できます。