Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like
LOAD Col1, col2, IF(NOT Match(TYPE, 'Others'), TYPE) AS TYPE
FROM yoursourcetablename;
Try This,
Load *, IF(Match(TYPE, 'Others'), 'Other', TYPE) as NEWTYPE;
Load * Inline [
TYPE
Other
Others
missing
customs
];
if(Match(TYPE,'Others'), 'Other', TYPE) as your field
resident previousTable..