What is the expected output of union(ri!fruits, ri!vegitables) if inputs are text arrays?

What is the expected output of union(ri!fruits, ri!vegitables) if inputs are text arrays?

• A. All items from both arrays, with duplicates removed
• B. Concatenation of the two arrays as strings
• C. Only items present in both arrays
• D. An error due to type mismatch

Answer: (A)

Union takes every element that appears in either input and removes duplicates, returning a single list of distinct items. Since both inputs are text arrays, the output is a text array that includes all unique items from both lists. If something appears in both lists, it will appear only once in the result. The items from the first array keep their order, and any new items from the second array that aren’t already present are added after. This is why the result is all items from both arrays with duplicates removed.

Union takes every element that appears in either input and removes duplicates, returning a single list of distinct items. Since both inputs are text arrays, the output is a text array that includes all unique items from both lists. If something appears in both lists, it will appear only once in the result. The items from the first array keep their order, and any new items from the second array that aren’t already present are added after. This is why the result is all items from both arrays with duplicates removed.