May I ask what i should edit for this error?
My task:
Only one row of each FA number is shown
About the issue:
we use a container and refer to the Container Scope Variable (Excel)
Crossreference:
Hi @Happydayyy
You have to use the Remove Duplicates activity inside Use excel file activity,
→ Insert Use excel file activity and give the path of the file.
→ Inside Use excel file insert the Remove Duplicates activity and give the range as below,
Excel.Sheet("FA for 4N")
Check the below workflow for better understanding,
Hope it helps!!
Where you are using the Use excel file activity I can’t find it in the Screenshot… @Happydayyy
Could you share an image where you have inserted Use excel file activity.
FA final + delete duplicate.xaml (66.0 KB)
I have updated your code, please check the below workflow… @Happydayyy
FA final + delete duplicate.xaml (68.5 KB)
It may happens due to version issues,
check the below workflow image, based on that do modifications,
Hope you understand!!
Thank you so much!!!
After I add the addition path under roll value, but why the number still running like that
If there only have 6 row, it is supposed there is 1-6 in column A, how to delete the 7 as well.
It may happens due to your code, check the code why it was writing in debug mode… @Happydayyy
I hope you find the solution for your query, If yes make my post mark as solution to close the loop.
Happy Automation!!
I check for several times and it seems work normally. Can you or someone can help me fix this issue?
Close the present thread if the duplicate values deleted query resolved… @Happydayyy
Create a new post for the further queries.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
fvalencia
hentsou_mamy