変換
Data Manager is included in all Service Collection Premium and Enterprise plans.
Transform functions are short sections of code that can be added to a data source to modify the raw data as it’s brought into Data Manager. No functions are enabled by default, but there are several functions that can be added.
A function added to a data source will be run when that data source is fetched.
You cannot use a transform function until a data source has been run at least once to upload the data from the Adapters client.
Typically, transforms are added to a data source to clean up or improve the formatting of fields that are being copied from a data source. For example:
デバイスのメモリ量を保持するフィールドは、Set Column Type 関数を追加してデータ型を「Big Int」に変更し、後でフィールドを検索またはフィルタリングできるようにすることで拡張できます。
VCenter のホスト名を保持するフィールドは、Remove Right Substring 関数を使用してピリオドの後に続く情報をすべて削除することで消去できます。
Transform functions and Cleansing rules are not the same!
変換関数 | 目的 | コメント |
|---|---|---|
右の部分文字列を削除 | 文字列フィールドから区切り文字の右側を削除します。 | 影響を受ける列または属性の名前を指定する必要があります。 |
文字列の置換 | 文字列フィールドの古い文字を新しい文字に置き換えます。 | he column or attribute name that is impacted must be specified. |
DateDiff 列を追加 | Adds a column to the table containing data retrieved from the data source and fills it with the number of days between the specified column and a base date. | The column or attribute name that is impacted must be specified. For the difference to be calculated, a base date needs to be specified in dd/mm/yyyy format. If the base date is not specified, the transform uses the current date. |
IP サブネット範囲の計算 | サブネットを CIDR ロングレンジに変換します。 | The subnet column name of the table needs to be specified. This is the table which contains the data retrieved from the data source. |
Concatenate two columns | Allows two columns to be concatenated together. | You’ll need to specify the new concatenated column name, the two columns you want to concatenate, and a separator (for example, whether you want the two columns separated by a comma, a hyphen or a space). Note: You can also concatenate a concatenated column after a transform is ran. This allows you to bring together more than 2 columns. |
文字列を日時に変換 | 文字列フィールドを日時フィールドに変換します。 | ソース列の日付形式を指定する必要があります。選択する形式は、Microsoft に準拠した形式のリストから選択する必要があります。 |
位置を見つける | Adds the location data to the table. It is based on IP analysis of the data source that produces the subnet/sites and services table. | The subnets data source name must be specified. |
列名を正しい文字列に変更 | 既存の列の名前を変更します。そうすることで、右側から古い列名を部分的に照合します。 | As an example suppose you already have an |
Null で置換 | NULL 値を持つ列/フィールドを置き換えます。 | The value(s) to be replaced with NULL and column name must be specified. Multiple values need to be separated with a comma between them. |
列タイプの設定 | Sets the data type for the column/field/attribute in a table. This is the table which contains retrieved data from the data source. | 列名とデータ型を指定する必要があります。 |
Trim right by count | Removes characters from the right side of a column value. | The column name and the number of characters to remove. |
Trim right by pattern | Removed characters from the right side of a volumn value, but only for rows where the column value matches a specified patter. | The column name, the number of characters to remove and the specified pattern to match. |
この内容はお役に立ちましたか?