I would like to create this kind of query with Knime. I would like to know if it is possible. Any advice of how I should proceed
speak(“Please enter your Global ID and Password, the product name, Number of days, and wafer Site”);
DLG = DIALOG( Title(“Chunk qual yield”),
HList(
VList(
Lineup(2,"Please Enter Global ID: ", GID=EditText(“xxxxxxxxx”),
"Please Enter EDW Password: ", PASS=EditText(“xxxxxxxxx”),
"Please Enter Product Name: ", prod=EditText(“xxxxxxxxx”),
"Number of days to go back: ", days=EditText(“22”),
“Select wafer site:”,
site=RadioButtons(“XXX”,“XXX”),
“Select wafer type:”,
pem=RadioButtons(“XXX”,“XXX”)
));
);
);
if (DLG[“button”] == -1, print(“Cancel was pressed.”); throw());
print(“So you really want data”);
show(DLG);
Removefrom(DLG,7);
scottlist=evallist(DLG);
prod=(scottlist[3]);
days=(scottlist[4]);
site=(scottlist[5]);
pem=(scottlist[6]);
GID=(scottlist[1]);
PASS=(scottlist[2]);
SHOW(prod);
SHOW(days);
SHOW(site);
SHOW(pem);
SHOW(GID);
SHOW(PASS);
IF(site==1,site1=“XXX”);
IF(site==2,site1=“XXX”);
show(site1);
IF(pem==1,pem1=“XXX”);
IF(pem==2,pem1=“XXX”);
show(pem1);
SELECTSTATE=“PROD_NAME IN (’”||xxxxxxxxx||"’)";
dlgStatus = new window(“Progress”,
dlg_gb = graph box(
Title (“Data Loading Progress”),
FrameSize ( 200, 30),
xscale(0,100),
yscale(0, 1),
yaxis (show major ticks (0), show minor ticks (0)),
xname("% complete"),
yname("")
)
);
dlg_gb[AxisBox( 2 )] << Delete;
dlg_gb[AxisBox( 1 )] << Delete;
speak(“Retrieving “||xxxxxxxxx||” data”);
dlgStatus[FrameBox(1)] << Add Graphics Script({Fill Color(“blue”),Rect(0,1,25,0,1)});
wait(0.2);
dlgStatus[FrameBox(1)] << Add Graphics Script({Fill Color(“blue”),Rect(0,1,50,0,1)}); // 50% on a scale to 100% shown in the xscale above. does not get scaled to the pixel count in frame size()
wait(0.7);
dlgStatus[FrameBox(1)] << Add Graphics Script({Fill Color(“blue”),Rect(0,1,75,0,1)}); // 50% on a scale to 100% shown in the xscale above. does not get scaled to the pixel count in frame size()
wait(0.7);
SHOW(days);
show(SELECTSTATE);
If ( prod == “xxxxxxxxx” & pem1 == “xxxxxxxxx”,
SELECTSTATE = “PROD_NAME LIKE ‘xxxxxxxxx%’”;
);
dt=expr( Open Database(“DRIVER={Oracle in instantclient11_1};DBQ=OKPEDW1;UID=”||xxxxxxxxx||";PWD="||xxxxxxxxx||";",
expr("select
Thanks
Pio