SCD?

[surajap123]

Hi Experts,

I wanted to change data conditionally. In the field Loc, for the value TBA the region should be changed to ME starting from year 2016. So any data before Year 2016 should be unchanged.

LOAD *

INLINE [

    No, Loc, Region, Year

    1, RCA, EU, 2015

    2, MNK, AK, 2015

    3, CBN, EU, 2015

    4, KLA, AP, 2015

    5, TBA, AP, 2015

    6, GRN, EU, 2015

    7, CPN, ME, 2015

    8, TBA, AP, 2016

    9, GRN, EU, 2016

    10, CPN, ME, 2016

];

Thanks

[jmvilaplanap · Accepted solution]

Main:

LOAD *

INLINE [

    No, Loc, Region, Year

    1, RCA, EU, 2015

    2, MNK, AK, 2015

    3, CBN, EU, 2015

    4, KLA, AP, 2015

    5, TBA, AP, 2015

    6, GRN, EU, 2015

    7, CPN, ME, 2015

    8, TBA, AP, 2016

    9, GRN, EU, 2016

    10, CPN, ME, 2016

];

NoConcatenate

Main_aux:

LOAD

    No,

    Loc,

    if(Loc = 'TBA' AND Year >= 2016, 'ME', Region)        AS Region,

    Year

Resident Main;

DROP Table Main;

[varshavig12]

Something like this,

Exp:  if(Year>=year(today())and Loc='TBA','ME',Region)

[avinashelite]

try like this

If(Year>=2016 and Loc='TBA','ME',Region) as Region