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.
Our internal data warehouse (DW) exports business reports into a CSV file before sending it Alteryx for processing. The CSV file contains 500,000 plus rows of data. The file will export the product number in the format shown below (see table). A manual intervention is performed to convert the contents of the product number in the table below to a 'Number', using the following formula -
On saving and closing the CSV file, the changes made are not retained and therefore the contents of the CSV file returns to its original state before the manual intervention. With that said, I would be grateful for some advice on how I can complete the manual excel intervention in alteryx. Any suggestions would be greatly appreciated. Thanks in Advance.
Many thanks @Danilang for taking the time to reply to my post. Yes, the data is lost as a result of scientific notation. Our product numbers are seven digits in length and typically follow the following format N,N,N,A,,N,N. (N= Numeric & A = Letters). Nearly all of our letters begin with a 7 but that is not strictly true as presented in the example above .