Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator II

issue

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.

3 Replies
vishsaggi
Champion III
Champion III

Try like

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

FROM yoursourcetablename;

qv_testing
Specialist II
Specialist II

Try This,

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

Load * Inline [

TYPE

Other

Others

missing

customs

];

shiveshsingh
Master
Master

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


resident previousTable..