Simplified Data Merge
Description
This activity merges the data result from the previous activities all together
Input
Data Only
Output
Merged data
Configuration Fields
- Tables Activities to be merged
- Merge Type Type of merge required(options 1.merge all columns, 2.Merge only common column)
- Use Fuzzy Join Merge using fuzzy join
- Threshold Threshold to specify the merge
Input Data (Activity 1)
| category | value |
|---|---|
| Electronics|Mobiles|Computers | 10 |
| Home|Kitchen|Furniture | 20 |
| Home|Kitchen | 20 |
| Furniture|Kitchen|Electronics | 20 |
| Electronics|Mobiles|Furniture | 20 |
Input Data (Activity 2)
| category | value |
|---|---|
| Electronics|Mobiles|Computers | 30 |
| Home | 40 |
| Kitchen | 50 |
| Furniture|Kitchen|Electronics | 20 |
| Mobiles|Furniture | 30 |
Sample Configuration
Output Data
| category | value |
|---|---|
| Electronics|Mobiles|Computers | 10 |
| Home|Kitchen|Furniture | 20 |
| Home|Kitchen | 20 |
| Furniture|Kitchen|Electronics | 20 |
| Electronics|Mobiles|Furniture | 20 |
| Electronics|Mobiles|Computers | 30 |
| Home | 40 |
| Kitchen | 50 |
| Furniture|Kitchen|Electronics | 20 |
| Mobiles|Furniture | 30 |