Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I like to record reject code, 114 = Reject by human error 113= Reject by machine problem.
My SQL load script as below i get error msg :-
LOAD
if(kode_reject=114,"reject human error")
if(kode_reject=113,"reject machine error") as DESC_REJECT;
select * from record_reject_detail_plc;
Paul
Hi Sergey
Just test found your working :-
LOAD *,
Pick(Match(kode_reject, 5, 39), 'reject human error', 'reject machine error') AS DESC_REJECT;
SQL select * from record_reject_detail_plc;
Paul
Hi Jagon
the correct one should be :-
LOAD *,
Pick(Match(kode_reject, 5, 39), 'reject human error', 'reject machine error') AS DESC_REJECT;
SQL select * from record_reject_detail_plc;
Hi,
Paul
LOAD *,
Pick(WildMatch(kode_reject, 114, 113, '*'), 'reject human error', 'reject machine error', 'N/A') AS DESC_REJECT;
SQL select * from record_reject_detail_plc;
For testing I put 200, you can replace 200 with your actual field name.
Regards,
jagan.
If you need N/A
just use the following:
LOAD *,
Pick(WildMatch(kode_reject, 5, 39,'*'), 'reject human error', 'reject machine error','N/A') AS DESC_REJECT;
SQL select * from record_reject_detail_plc;