The Advanced Import feature allows you to import files from gINT or Excel using advnaced transformation methods. These methods can transfer, modify, and merge data from one table to another. Below is a brief explanation for each transformation type in simple terms.
This module can be accessed at www.boredmlogs.com/advanced-import. Please only use this module for testing purposes; Mappings created during the Beta phase may be deleted at any time.
Map Transformation
This method is used to replace certain values in your dataset. If a specific value is found in a column, it is replaced with a new value.
Example: If a column contains "NYC," you can replace it with "New York City."
If the value to replace is "*", it replaces all values in that column with the new value.
Identity Transformation
This method is a simple copy-paste from one table to another. It directly transfers values from specified fields in the source table to corresponding fields in the destination table.
Example: If you have a "Customer Name" column in one table, it copies the names into the corresponding column in another table without changes.
Identity with Fallback Transformation
This works like Identity Transformation, but with a backup option. If the main field is empty or missing, it will try using a list of fallback fields instead.
Example: If "Email" is missing, it can use "Phone Number" as a fallback.
Math Transformation
This method performs basic mathematical operations on a column by adding, subtracting, multiplying, or dividing by a fixed number.
Example: If you want to increase all prices in a column by 10%, you can multiply each value by 1.1.
Conditional Join Transformation
This method combines data from multiple tables based on specific conditions. It ensures only rows meeting the conditions are merged.
Example: If you have a "Customer Orders" table and a "Customer Details" table, you can join them using a common field like "Customer ID."
Inter-Column Math Transformation
This method performs math operations between two columns in the same table. Instead of a fixed number, the calculation is done using values from another column.
Example: If you have a "Total Price" column and a "Discount" column, you can subtract the discount from the total price.