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

[SergeyMak]

Hi Paul,

It would be better

LOAD *,

if(kode_reject=114,'reject human error'),

     if(kode_reject=113,'reject machine error')) as DESC_REJECT;

select * from record_reject_detail_plc;

Regards,

Sergey

[SergeyMak]

Or you can use

LOAD *,

Pick(Match(kode_reject, 114, 113), 'reject human error', 'reject machine error') AS DESC_REJECT;

select * from record_reject_detail_plc;

Regards,

Sergey

I prefer this option

[#4]

Hi,

Use this

LOAD

if(kode_reject=114,'reject human error',if(kode_reject=113,'reject machine error')) as DESC_REJECT;

select * from record_reject_detail_plc;

Regards,

Navdeep Kumar

[albertovarela]

Don't forget to add  SQL before the select ......  SQL select * from record_reject_detail_plc;

[SergeyMak]

You are correct

So it will be

LOAD *,

if(kode_reject=114,'reject human error'),

    if(kode_reject=113,'reject machine error')) as DESC_REJECT;

SQL select * from record_reject_detail_plc;

or

LOAD *,

Pick(Match(kode_reject, 114, 113), 'reject human error', 'reject machine error') AS DESC_REJECT;

SQL select * from record_reject_detail_plc;

Regards,

Sergey

[jagan · Accepted solution]

Hi Paul,

Try this script

LOAD *,

Pick(WildMatch(200, 114, 113, '*'), 'reject human error', 'reject machine error', 'N/A') AS DESC_REJECT;

SQL select * from record_reject_detail_plc;

Hope this helps you.

Regards,

jagan.

[paulyeo11]

Hi Sergey

Thank , it work fine now :-

LOAD *,

day(date_time)      as [day],

year(date_time)      as [Year],

Date(Monthstart([date_time]), 'YY MMM') as YearMonth,

if(kode_reject=50,'reject human error',

     if(kode_reject=5,'reject machine error')) as DESC_REJECT;

select * from record_reject_detail_plc;

Paul

[paulyeo11]

Hi Jagan

Thank you , i like the N.A portion.

Paul

[paulyeo11]

Hi Jagan

when i try your code again , i notice there are some issue :-

LOAD *,

Pick(WildMatch(200, 114, 113, '*'), 'reject human error', 'reject machine error', 'N/A') AS DESC_REJECT;

SQL select * from record_reject_detail_plc;

why you does not include the Kode_reject name ?

200 does not equal reject human error

114 does not equal reject machine error

can you share with me how your code work ?

Paul