Need help regarding below stated issue.

[Mohd-Siddiqui1]

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

[afv2688]

Hello @Mohd-Siddiqui1 ,

I think that by using a simple join here would be more than enough for what you are looking for.

Look at my example and let me know 🙂

Regards