Hi there,
I have the below mentioned output which I am getting from one workflow through output tool.
Country | 2020 |
Abc | This is dummy line and this section contains some paragraph |
Xyzb | This is dummy line and this section contains some paragraph |
Pqrst | This is dummy line and this section contains some paragraph |
Defghijk | This is dummy line and this section contains some paragraph |
Mnopqr | This is dummy line and this section contains some paragraph |
Abcde | This is dummy line and this section contains some paragraph |
Lmnopqrstuvw | This is dummy line and this section contains some paragraph |
RowNotPresentInExcelSheet | This is dummy line and this section contains some paragraph |
Workflow's output
The above data is the output of one workflow and I want year (i.e. 2020) column to be appended to original excel sheet data based on below mentioned conditions:
Note: Original excel sheet is the file in which output of the workflow has to be written.
1. Append year column in the original excel sheet:
- if country name which is present in workflow's output and if it is not present in original excel sheet then it should append both Country column and year column to the original excel sheet.
- if country name is not present in workflow's output and if it is present in original excel sheet then it should only write "N/A" in year column for that country name in the original excel sheet.
Please find below dummy original excel sheet.
Country | 2020 |
Abc | This is dummy line and this section contains some paragraph |
Xyzb | This is dummy line and this section contains some paragraph |
Pqrst | This is dummy line and this section contains some paragraph |
Defghijk | This is dummy line and this section contains some paragraph |
Mnopqr | This is dummy line and this section contains some paragraph |
Abcde | This is dummy line and this section contains some paragraph |
Lmnopqrstuvw | This is dummy line and this section contains some paragraph |
RowNotPresent | This is dummy line and this section contains some paragraph |
