Problem statement : I am having two excel files and trying to assign value of a column from one excel to another .While applying i tried lookup activity but it is not working accordingly.
The output is like “for repeated values (like 2 & 3 here) , the status of assigned values will be of the same order(like for 2 its No then Yes) order should be same .”
Thanks @Palaniyappan but this is the reason i asked that how should i solve this confusion because the result should be like it assign Yes to first “2” and then No to second “2” and so on in the same sequence.
I am unable to find the best solution that how will it work.
But a small doubt is it for only 2 or the same for same for all numbers like here in the example I could see like 5 occurs only once but is assigned with No, but it should be Yes right for being the first value
Thanks @Palaniyappan The thing is, for duplicate numbers the values should be assigned in the same order (irrespective of Yes or No coming first)and for single ones it will be the same . Yes and No are status which can change .
There is no relation between numbers occuring once with Yes or No and numbers occuring twice with Yes or No.
The input and output will be like shown in file1 and file2 respectively
The scenario looks like a clasical “the bot is not me” problem. Such a problem can be identified by checking on following: Is in the requirement description / processing rule definition a part of cognitive action, that is omited?. Because of this lack, the implementation is challenging.
Lets map this to your scenario:
look up / Join will let us lose 2-Yes, 2-No case, due first found value will be picked up
the cognitive part is that the eye looks on the downer line, identifies the other line 2-No and is adding this to the report as well.
currently File 1 is nothing else as File 2 without column Quality and is in another order. Now we have to dig more within the requirements and have to look on a case on Row count File 1 is not Row Count File 2. From this case we can further rules.
Maybe following approach can be used and implemented:
iterate over list 2
lookup for number in list 1
if found - use it, if not found use “not found” or leave it empty
if lookup value is used mark it internaly as used, and do lookup on next not used value
@Soniya215 maybe you can gather some more rules / requirements so @Palaniyappan, me can help you on the setting up the appropriate solution approach
As of now, the code will work only if the Excel1 and excel 2 has same set of numbers.
eg, if 2 is in 3 times in excel 1 the in excel 2 also it should be 3 times
@ppr and @MuralidharVankamaddi I am very thankful to you for the help. @MuralidharVankamaddi the workflow is working but if i have some condition like the output file contain a row which is not present in input file then it is assigning “No” to it whereas it should skip that row (i.e. do nothing). Where should i apply this condition in your workflow. For example
**This is input file ** This is resulting output file
It should skip the 5th row but it is assigning “No” to it . Why is it so?
Please help.
Please assign a null value toy he “output” status before the second loop.
So, it will skip the row which is not present in the input file and also if input file(reference) has number 2 as two times and output file has 2 has more than two time the bot will assign the respective status for first 2 items and skip the remaining Number “2”