Add column based on a user input.I made a script which gives a pop box to enter suspected wafer list. Than it will add a column to the table with using If loop. This script is working fine when Wafer data type is Character but it doesn't work with Numerical type data type. How can I fix this?
dt = Current Data Table(); // Get the current data table
nw = New Window("Enter Shop order",
<<MODAL></MODAL>

Basic Data Analysis and ModelingRe: Add column based on a user input.Most likely easiest option is to wrap your :Wafer column in the formula with Char()
dt << New Column("Suspected", Formula(If(Contains(myValueList, Char(:Wafer)), "Yes", "No")));