Problem with mapping load and apply map

[trishita]

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);

[trishita]

Because I am having redundant data as the fuel type of the two tables are not mapped

[sunny_talwar]

Unfortunately, I am not able to understand the problem. Are you able to share a qvw file?

[trishita]

PFA

[trishita]

Hi Sunny, I have uploaded the qvw

[sunny_talwar]

Sorry, it is been few days before I last saw this, would you be able to briefly explain (too lazy to read the whole thing again) what are we trying to do and what from the qvw sample doesn't look right