Skip to main content
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

How merge several fields of flags into 1 field

On the main table transaction (which has over 100 million records) I have 10 flag fields with the value 0 or 1 ([field1_flag], [field2_flag], ..., [field10_flag]). I want to change all flag fields to 1 flag field type of binary (maybe string)  (eg: [all_fields_flag]) with values like: 000010001. I want take value from field [all_fields_flag] eg: 5 character and multiply with another field of transaction field. Do You have example about this? Thanks in advance.

Labels (2)
1 Reply
Partner Ambassador
Partner Ambassador

Please try:

[field1_flag]&[field2_flag]&[field3_flag]&[field4_flag] etc.

will give you the string wanted '0010101010'

So you are just concatenating the fields with '&' character