This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi all... I imagine the solution to this is over my head, but I'm going bonkers and need help I created a workflow working from a worksheet in XLSX... turns out the source file is actually XLS. Everything comes in as VWString and when I convert it to any numerical value of any kind to match the original data format t is dropping the values that are negative (in parenthesis) and making them null. The positive numbers don't drop.
Any suggestions? Is there a tool to convert the negatives before I make numerical?