I am getting error as failed to convert from text to collection.
could you pls explain how to do this conversion.. let me know how you have created that input.data
Step 1 and 2 works whereas the calculation stage stores result only in data item.
I want the output in collection as I need to write it back to the excel.
Hi All,
I have an column which contains value with % symbol like
10%
20$
30%
67$
Now I need to remove this % and $ symbol and should have value alone in a separate column.
Please assist on this.
Hi Amlan,
Thanks for your response.
I tried in the same way but it throws error at the merge stage (as I have same headers on all the 4 sheets)
Internal : Could not execute code stage because exception thrown by code stage: A column named 'name' already belongs to this DataTable.
Please let...
Hi All,
I have a workbook with few sheets with same headers.
I have to get all the worksheets names (Did via MS Excel VBO) and then I have to copy the data from all the worksheets and paste it in a single sheet
Please assist on this
Hi All,
I want to extract only the word when its present along with the non word characters.
But when I tried with the string VBO I get the result as same as the input. PFA
Appreciate your help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.