topic Re: SCD? in QlikView

SCD?

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: SCD?

jmvilaplanap — Fri, 26 Aug 2016 06:55:56 GMT

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;

Re: SCD?

varshavig12 — Fri, 26 Aug 2016 06:56:11 GMT

Something like this,

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

Re: SCD?

avinashelite — Fri, 26 Aug 2016 07:01:52 GMT

try like this

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