SQL script on record label for example 114 human error 113 machine error.

[paulyeo11]

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

[paulyeo11]

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

[paulyeo11]

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;

[jagan]

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.

[SergeyMak]

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;