Icon

sandbox

If experiment matches regex ^\d{2}(?<=21)[0-3].{2}(in my example, 2126b, 2135a, 2137a, 2138b)then write to new column "String" using value from column "String A"If experiment matches regex ^\d{2}(?(?<=21)[4-9].{2}|.{3})(in my example, 2145a, 2145b, 2237a, 2245a)then write to new column "String" using value from column "String B" Node 1Node 2Node 3 Ideal OutputNode 6Table Creator Column Filter Table Rowto Variable Table Creator Chunk Loop Start If experiment matches regex ^\d{2}(?<=21)[0-3].{2}(in my example, 2126b, 2135a, 2137a, 2138b)then write to new column "String" using value from column "String A"If experiment matches regex ^\d{2}(?(?<=21)[4-9].{2}|.{3})(in my example, 2145a, 2145b, 2237a, 2245a)then write to new column "String" using value from column "String B" Node 1Node 2Node 3 Ideal OutputNode 6Table Creator Column Filter Table Rowto Variable Table Creator Chunk Loop Start

Nodes

Extensions

Links