issue

[vinod2086]

Hi ,

I have a column (TYPE) contains below

TYPE
Other
Others
missing
customs

Here i want to display instead of Others need to show Other and remaining fields.

[vishsaggi]

Try like

LOAD Col1, col2, IF(NOT Match(TYPE, 'Others'), TYPE) AS TYPE

FROM yoursourcetablename;

[Nagaraju_KCS]

Try This,

Load *, IF(Match(TYPE, 'Others'), 'Other', TYPE) as NEWTYPE;

Load * Inline [

TYPE

Other

Others

missing

customs

];

[shiveshsingh]

if(Match(TYPE,'Others'), 'Other', TYPE) as your field

resident previousTable..