Hi, i am trying to get the desired output column by all ways but i am unable to get it. Please help.
Solved! Go to Solution.
Hi @SP3000 ,
The below formula should give you the desired output.
if isnull([Desired Output]) and [RecordID]=1 then [Data]
elseif isnull([Desired Output]) and [ID 2]=[Row-1:ID 2] then [Row-1:Desired Output]
else [Data]
endif
Also attached is a sample workflow to showcase the same.
Hope this helps.
Best,
Jagdeesh
Hi @SP3000
I am bit confused with your input data and output data. Can you please explain how you arrived at the output data whats the logic applied?
Firstly, Thank you so much for responding and taking your time out to help. I truly appreciate your kind assistance.
The logic is basis the ID2 col if the id no. is repeating then the data should be updated with the first data of the same ID no. For eg. in ID2 col, ID no 3 & 4 is repeating twice each, so the data/desired output should be updated with Japan for ID2 and Korea for ID4.
@SP3000 ,
for 4 in [ID 2] column, how is 'Korea' getting populated there? Shouldn't it be Australia?
Similar case for 5 in [ID 2].
Can you please share a separate Input data sample and output data?
Regards,
Shreyansh
Hi @SP3000
Or you can you can use find and replace with works like excel vlookup.
Workflow:
Hope this helps : )
thank you so much @atcodedog05 ..i really appreciate it!