Create a column and fill data based on condition

Help Activities
1

I have 2 input.txt

Input1 text file has
Column1 as xyz
Column2 as 0
Column3 as 1

Input2 text file has
Column1 as xyz
Column2 as 10
Column3 as 3.4

What I am trying to achieve is
If column 2 of input 1 is 0 then create Column4 in input2 and pass the value of Column3 (input1) to it

Can anyone help to get this in a text file (I do not have Excel)

2

Hi @dipon1112000
Please take a look to this workflow. Hope it helps.
I used csv files instead txt, but conversion you can do yourself.
BlankProcess75.zip (5.9 KB)

3

Thank you very much :pray:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.