- Merge CSV
- Process CSV for VLOOKUP
python setup.py
- VALUES_TO_BE_REPLACED_BY_NULL
- CHUNK
- PARENT_FILE_LOCATION
- CHILD_FILE_LOCATION
- PARENT_PRIMARY_KEY
- CHILD_FOREIGN_KEY
- SOURCE_COLUMN_NAME
- PARENT_SOURCE_VALUE
- CHILD_SOURCE_VALUE
- CHILD_COLUMN_TO_FETCH_DATA
- PARENT_COLUMN_TO_PLACE_DATA
- MERGE_DATA
- REPLACE_DIFFERENCE
- VLOOKUP
- MERGE_HEADERS
- CLEAN_EMPTY_COLUMNS
- ADD_SOURCE_COLUMN
- OUTER_JOIN
- OVERRIDE_PARENTDATA
For running a script to merge 2 CSV
python run.py
| Id | Name | |
|---|---|---|
| 2 | Bb | |
| 3 | C@b.com | |
| 4 | Db | D@b.com |
| 6 | Gb | |
| 8 | F@b.com |
| EXT_Id | Name | |
|---|---|---|
| 1 | Ab | a@b.com |
| 2 | b@b.com | |
| 3 | Cb | |
| 4 | asdf | as@df.com |
| 5 |
| Id | Name | EXT_Id | SOURCE | |
|---|---|---|---|---|
| 6 | Gb | Master | ||
| 2 | Bb | b@b.com | 2 | Master/Child |
| 3 | Cb | C@b.com | 3 | Master/Child |
| 4 | Db | D@b.com | 4 | Master/Child |
| 8 | F@b.com | Master | ||
| Ab | a@b.com | 1 | Child | |
| a@b.com | 5 | Child |
| Id | Name | EXT_Id | SOURCE | |
|---|---|---|---|---|
| 2 | Bb | b@b.com | 2 | Master/Child |
| 3 | Cb | C@b.com | 3 | Master/Child |
| 4 | Db | D@b.com | 4 | Master/Child |
| Id | Name | EXT_Id | SOURCE | |
|---|---|---|---|---|
| 2 | Bb | b@b.com | 2 | Master/Child |
| 3 | Cb | C@b.com | 3 | Master/Child |
| 4 | asdf | as@df.com | 4 | Master/Child |
| Id | Name |
|---|---|
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
| 5 | e |
| f | |
| g | |
| i | |
| j |
| Old_Id | New_id | Name |
|---|---|---|
| 1 | 100 | a |
| 1 | 1000 | aa |
| 2 | 200 | b |
| 3 | 300 | c |
| 4 | 400 | d |
| 5 | 500 | e |
| 6 | 600 | FF |
| 7 | 700 | GG |
| 8 | 800 | HH |
| Id | Name |
|---|---|
| f | |
| g | |
| i | |
| j | |
| 100 | a |
| 200 | b |
| 300 | c |
| 400 | d |
| 500 | e |