23-06-25 02:59 AM
I am new to Blue Prism, and I am trying to do some relatively easy automation (at least I thought so). I started with opening 3 local csv files in excel, adding the data to a collection for each file, then creating one collection by appending rows to the main collection. It worked perfectly about 10 times -- now I'm getting this error:
Internal : Could not execute code stage because exception thrown by code stage: A column named 'Labels' already belongs to this DataTable.
I can't figure out what it means.
Answered! Go to Answer.
23-06-25 03:34 AM
Hi @rgwhisenant ,
If you are using Append Rows to Collection action from Collection manipulation Utility, Both Main & Collection to append should have same set of fields.
Please check the below,
1. check your collection has any extra columns than the main collection
2. Check collection columns have different data type(e.g label - column is text in main but new collection automatically detects it as number)
3. Check your columns are in same order
Let me know if you are able to solve the issue.
Thanks,
Nandha
23-06-25 03:34 AM
Hi @rgwhisenant ,
If you are using Append Rows to Collection action from Collection manipulation Utility, Both Main & Collection to append should have same set of fields.
Please check the below,
1. check your collection has any extra columns than the main collection
2. Check collection columns have different data type(e.g label - column is text in main but new collection automatically detects it as number)
3. Check your columns are in same order
Let me know if you are able to solve the issue.
Thanks,
Nandha
23-06-25 10:29 PM
Thank You -- I figured it out -- the file structure I was downloading changed.