Incremental load logic

[kulasekhar]

Hi All,

I have one requirement on Incremental load. I have Primarykey in my table but i don't have modification time.My requirement is when i reload the QVD generator i only want to delete current and Previous months from QVD and again i need to add current and Previous month data from Database to QVD because i don't have modification time.

But the problem is I created fiscal year which starts from november,If i reload the data now then it should delete current Month(as per fiscal year it is 3rd month) and Previous month(as per fiscal year it is 2nd month) and again add to QVD.

I'm attaching sample QVW also.

Can anybody help me with sample QVW or Code will be helpful for me. It's an immediate requirement.

Thanks,

Sekhar

[kulasekhar]

Hi Guys,

Any ideas on this?

Thanks,

Sekhar

[kulasekhar]

Hi Guys,

using this i want to filter data : 

condition1)   if two '_' (Underscore's) are there , i want middle value

condition 2)  if one '_' score there i want first value before underscore

condition 3) if there is no underscore i want the same value as it is,

all three conditions should be for that field ,, save result in new field.

GROUPNAME

EGR_EGTS_BATCH

IPG_PMRD_ADM

IPG_PMDE_ADM

GIT_OVSC_ADM

GIT_OVSC_BATCH

ITIO_ITR_BATCH

Srinivas_Vandrasi

EGIT_EGSD_BATCH

EGIT_PRAO_BATCH

EGIT_EGSD_ADM

PPS_PCSC_ADM

GREP_HRPY_ADM

GREP_HRPY_BATCH

ITIO_ITR_BATCH

IPG_USAG_ADM

BASL_ADM

EGIT_PRAO_ADM

ITIO_ITR_ADM

GIT_MDM_UPU

EDS_SXD_ADM

GIT_EDW_BATCH

IPG_LOT_BATCH

Administrator

GIT_MDM_ADM

PPS_PCSC_BATCH

Thanks,

sekhar.

[gandalfgray]

Hi sekhar

First may I suggest you start a new thread when you have a completely new question.

This last question is not about incremental load logic.

Anyway, one way to do what you want is:

new:

LOAD GROUPNAME,

    if(underscores='', GROUPNAME,

        if(underscores='_', SubField(GROUPNAME,'_',1),

            if(underscores='__', SubField(GROUPNAME,'_',2), GROUPNAME&' Warning, more than two underscores, no rule defined.'))) As transformed_groupname;

LOAD GROUPNAME,

    KeepChar(GROUPNAME,'_') As underscores

Resident tab1;

Regards

/gg