348104_en-US

liliconcom

if condition

Hi, 

i have three tables lets call them dt_A, dt_B and dt_C. Data from tables dt_A and dt_B are either uploaded or concatenated into dt_C.

Since the data from dt_A or dt_B can be added into dt_ C by different users and can be generated at different times. Therefore, in order to avoid multiple adds into C, I have decided to check first if those already exists. My idea was simple:

 

 

date = dt_A:Name("measurement date")[i];
lot = dt_A:Lotname[i];
wafer = dt_A:WaferNumber[i];
chip = dt_A:Position[i];

for each row(
if(:Name("measurement date") == date & :Lotname == lot & :WaferNumber == wafer & :Position == chip, a = 1, a = 0);
);

// a = 1 if the values are found
// a= 0 if the values are not found

 

 

and here comes the issue that I faced. I have generated number of data in dt_A, some of those are already in the available in dt_C. Even if the condition is true, a =1,  the result is a = 0. 

 

However, when i run: 

 

dt_C << select where(:Name("measurement date") == date & :Lotname == lot & :WaferNumber == wafer & :Position == chip);

the row in dt_C is selected.  

 

Any ideas where the problem lies? 

Data TableRe: if condition

i have made some work around, and since the select function works without issues, therefore my solution was simply: 

dt_C << Select Where(
    :Name( "measurement date" ) == date:Lotname == lot & :WaferNumber == wafer & :Position == chip
);

If( N Rows( dt_C << get selected rows ) > 0,
    a = 1,
    a = 0
);

 

 

in this case the program always returns correct "a" value. And the further concept either concatenating or updating the data works without issues  

 

Re: if conditionTry using the Trim() function for :Position and Chip comparisonRe: if conditionthank you Jim for Your suggestions

indeed I have a line current data table(dt_C ) prior to for each row() function. I checked also with the date. It works without issues. What actually creates an error it is "chip" in the table :Position its format is character and modeling type is nominal. The chip is just a character. And here came an error.
i keep debugging it. Re: if conditionUsing For Each Row() can be confusing to JMP, in regards to what data table to do the operation on. Make sure it is running on the correct data table.
Are there any preceding or trailing blanks in the character variables in one or the other data table values?
Are the date values being saved and displayed in the same way. If you display a datetime value using m/d/y format, and it had a time component in the data, it will not be the same value as one that does not have such a time value