Breadcrumbs

Use Upload Rules

What are upload rules?

Upload Rules allow you to automate data transformation, validation, and enrichment during file uploads. Instead of manually cleaning or modifying your data before uploading, you can define rules that automatically process the data as it uploads to the system.

These rules:

  • Apply only during file upload

  • Independent of month and year

  • Trigger based on file type or module (e.g., cloud usage, vendors, invoices)

  • Can include filters to control when the rule should run

  • Can be enabled or disabled — disabled rules are skipped during upload processing

Why use upload rules?

Upload Rules help you:

  • Ensure consistent data formatting

  • Reduce manual data preparation

  • Automatically fill missing values

  • Standardize data across files

  • Apply business logic at upload time

Where can you use upload rules?

Upload Rules are available in:

  • Master Data

  • Account Payable

  • Lookup Types

  • Consumptions

  • Assets

  • Expenses

  • Companion Metrics

  • Recommendations

Model & entity support

Upload Rules can be applied for specific models or entities by using filter conditions.

By adding appropriate filters, you can:

  • Restrict a rule to a particular model

  • Apply rules only to specific entities or records

Upload rules for Cloud Consumption data

  • For cloud consumption uploads (Azure, AWS, FOCUS), the Account, Cost Center, and Vendor fields must be populated using Upload Rules. These fields are no longer available for selection during the manual upload process.

  • AI Service fields must be populated using Upload Rules. Mapping spend to the AI Service field allows for automatic population of AI attributes in the Cloud asset type during the publish process.

Key points:

Application contains the below by default upload rules to extract the tags:

  • Application Tag

  • Product Tag

  • Service Tag

  • Owner tag

  • Team Tag

  • Cost Center Tag

  • Department Tag

  • Environment Tag

  • Customer Tag

  • Component Tag

  • Tech Stack Tag

  • X_TaggingCompliance

  • Cloud spend cannot be published unless Account, Cost Center, and Vendor are assigned via Upload Rules.

  • Define Upload Rules for the cloud consumption source table to automatically populate these fields during file upload.

  • If you have already uploaded cloud data without these rules, you may delete the existing file, define the Upload Rules, and reload the file to apply the rules.

For step-by-step instructions on creating Upload Rules, refer to Manage Upload Rules.

Default upload rules for Owner Tag in Cloud Consumption

The application includes default upload rules to automatically identify and map business owner tags to individual cloud resources during cloud data ingestion.

How Upload Rules work

Each Upload Rule has:

  • a source area,

  • a destination field,

  • a rule type,

  • optional filters,

  • and optional settings such as Apply on empty fields.

During upload:

  1. Yarken checks the file type being uploaded.

  2. Matching Upload Rules are evaluated.

  3. Disabled rules are skipped — only enabled rules proceed to evaluation.

  4. Rules are applied to the selected destination field.

  5. Filters determine which rows qualify.

  6. The transformed values are loaded into the application.

Key components of a rule

Each rule includes:

  • Field to update
    The destination column where the result is applied.

  • Rule type
    Defines the transformation logic.

  • Filters (optional)
    Conditions that control when the rule runs.

  • Apply on empty fields
    Applies the rule only when the destination field is blank.

  • Comment
    Optional description for reference.

  • Enabled (on/off)
    Controls whether the rule is active. Disabled rules remain saved but are not executed during file uploads or data reloads. All rules are enabled by default.

Rule types in Upload Rules

Each rule type is created with a predefined condition that executes during file upload only when certain conditions are met. You may add the additional filter criteria to the rule types.

Yarken supports the following rule types:

Related content

Rule types