Create a variable that combines two string values

[viggor]

I have a simple question:

I have two variables foo and bar, each containing a set of strings, and I would like to create a new variable foobar which contains the union of foo and bar.

I am aware of the | set union command, but I don't seem to get it to work for this scenario.

[Sarmbrister]

Would an eval expression work in this case?

Example

search... | eval new_variable=foo. "" .bar

[richgalloway]

What do you mean by "union"? Can you give an example of your fields and desired output?

Have you looked at the mvzip function?

[somesoni2]

I believe you need to use mvappend command with mvdedup (to remove duplicates) with eval. If they're not multivalued fields, you have to convert them to mv first. We can suggest more accurate options if you can provide some sample values.