Adding two different data types in one column

jjhan0630

I'm trying to add two different data types in one column. 

For instance, I'm trying to use Multi raw formula to add times(column 12~7) to the dates in the same column. I know that Alteryx does not provide to different data types in one filed. 

How should I solve this?

apathetichell

Your columns will already be considered to be strings because they contain different types of data inside of them.

You can use [a]+[b] or [a]+" "+"[b] if you want to include a space.

If you want to convert them out to non-string types you can use todate()/tonumber() as needed and then perform calculations specific to that field, but keep in mind that your final product must be a string (or an error) if you are including different types of data in your column.

You can use a formula to do something like if regex_match([b],"\d+") then tonumber([b]) else null() endif - and then use a summarize on the resulting new column to get the sum of rows 1-7 - if that's what you are trying to do. Likewise you can create a date column by testing which entries include a date  (the regex match for a date could be \d{4}-\d{3}-d{3}) and then use date time functions with the new information.

It's probably be easier to keep unlike data in separate columns and then have formulas combine them as needed.