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.
I'm a newbie in Alteryx, and what I'm looking for is to separate characters that should belong to another column, so what I did was merge the two columns that had the problem and then used the text to columns tool to separate them using the space character as a delimiter, but when I applied it to my Alteryx, the number format changed to a date format. Below is the image with the issue and how it appears in the output of my Alteryx. What I want is to change the date format to number format.
Or please if you know how I can fix those numbers that should be in the left column (not in the right as the highlighted screenshot) please let me know.
@monigarza- Pls share a sample file so that we can help you. Images when running into transforming data doesn't help because we don't have data file to see the issue real and provide a solution. So, please attach sample data file you are parsing.
I'm so sorry for my late response, please find attached the document in Excel that I want to change, as you can see, on column L the dates are wrong, because some cells contains decimals that should be on column K, also on the last column, (V and W) I would like to separate the date from the payment method, (and join this last one, because the payment method is separated, as you can see it is written on column W, and X).
Would you like me to attach the alteryx that I have created? (but it's wrong formulated)
@monigarza - I reviewed your excel file and can't replicate the errors you mentioned. The dates seem to come out just fine and when the excel file is connected to alteryx, it works ok. Seems like your 'original' file may not be an excel file but a flat/csv/txt type of file....... because all the issues you mentioned in your problem are not visible on excel and when you connect the excel file to Alteryx, dates come out just fine. I would recommend that you give us a file (and workflow that you created to replicate issues you are seeing) that I can help.