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.
Is there a way to set all the fields as V_String ?
I will be using this in a batch Macro and the field names will change for each data set.
I know doing this will cause Alteryx to allocate more memory,but i am working on data comparison workflow and will need to compare the field.
When Alteryx is setting the field type automatically, field type is having mismatch causing the formula tool to through error.
Eg: In data set 1 Field "ABC" might be set as V_String,but in data set 2 Field "ABC" is being set as Double as the entire column is empty.I want both these fields to be set as V-String.and in each run this can change.So i want a dynamic option. Basically to set all the fields being passed to the Macro as V_string
Strangely enough this is something you can do easily with the multi-field formula tool.
Choose 'all types of' in the menu and check every field including the dybamic/unknown fields option.
Uncheck the option which says rename and add prefix.
Check the option to change the date type and set it to v_string.
Set the formula statement to be [_currentfield_].
Alternatively, you could wrap any values you use in your formula in a tostring() which then means, If the field comes through as a text or double, it will always be treated as a string within that specific formula.