Say I have a column with a string array arr[“abc 123”, “cab 543”, “bac 534”]I want to create a case transform such that:
if (condition1):
the value of arr that contains substring "abc"if
(condition2):
the value of arr that contains substring "cab"and so on
Could I do this using the case transform in pipeline builder?
Hi there,
It depends on what you’re trying to accomplish. If you want to create a value if any or all of these conditions are found within the entire array, case should work. You can check the first condition to see if its in the array and do something, then the next condition, and so forth. If you want to do something per condition, you can use the filter board to filter your array to the items that contains “abc” for instance, and then use that.
