I have to map two fields from two different tables which are already joined..I want to do it because if i dont map them properly they are showing me redundant data even if the tables are joined.please help me.
The logic is all the fuel type like DMA / DMC can be classifyed as 2 groups HSDO and LSDO on basis of sulphur content.If Fuel type is RMA ... RMG it can be classified as HSFO OR LSFO if sulphur content is more than 0.01 and less than 0.01 rspectively.
.I want to map them because with conditional logic they are still showing redundant data
I want to implement this in my mapping table...Could this syntax be like:
Could this syntax be like:
MAP1:
MAPPING LOAD
SURVEYID,
if(WildMatch([Fuel Type], 'DM*') and [Sulphur Content] = '>.01','HSDO',
if(WildMatch([Fuel Type], 'DM*') and [Sulphur Content] = ' <:01','LSDO',
if(WildMatch([Fuel Type], 'RM*') and [Sulphur Content] = '>.01','HSFO',
if(WildMatch([Fuel Type], 'RM*') and [Sulphur Content] = ' <01' ,'ULSFO'))))
as NIFuelType
FROM [mo_bun_sur_survey_view.qvd]
(qvd);
Main:
LOAD
SURVEY_ID,
applymap('MAP1',NIFuelType, 'Unknown') as ActualFueltype
FROM
[mo_purch_sounding_correction_view.qvd]
(qvd);
