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 have dozens of fields with initial data type "String". For every field that contains the word "DATE", I want to parse the string to a date format. I currently use the multi-field formula with this formula:
IF Contains([_CurrentFieldName_], "DATE") THEN DateTimeParse([_CurrentField_],"%d-%b-%Y") ELSE [_CurrentField_] ENDIF
Now I want to change the field type of those fields, where the condition was true, to "Date". If I check the box "Change Output Type", unfortunately, all fields (also the remaining string fields) get converted. How do I only convert the desired fields?
@UnknownUser I think you're headed down the same path I would have gone with this one. Multi-field tool is great, but since you need to be more precise about which columns you select, I would use the Dynamic Select to narrow to just those columns and an index to join on. Once those are converted, you can use the index to join back to the rest of the fields and a Dynamic Select again to remove the fields of the old format (since their name will start with 'Right_').