New Column Set Value Help
I know the following script is incorrect:
a = {"a", "b", "b"};
b = [1, 2, 3];
c = [4, 5, 6];
New Table( "SQL Results",
New Column( "a", character, set values( a ) ),
New Column( "b", formula( If( :a == "a", set values( b ), set values( c ) ) ) )
);
How do I change it to make the output:
a 1
b 5
b 6
so the first row checks if column 1 is "a", yes then use b[1]; se...
RVhydrA