SUB ExtendWhere(Name, ValVarName) LET T = Name & '_COLNAME'; LET ColName = $(T); LET Values = $(ValVarName); IF len(Values) > 0 THEN IF len(WHERE_PART) > 0 THEN //If WHERE clause exists then extend it with further values LET WHERE_PART = '$(WHERE_PART) AND MATCH($(ColName),$(Values))'; ELSE LET WHERE_PART = ' WHERE MATCH($(ColName),$(Values))'; //If WHERE clause does not exist then create it ENDIF ENDIF END SUB;
SET Sel_Implementation = ; //resets the variable from any previous reload SET Sel_Implementation = $(od_Implementation); // follow 'ods_' with the field name as it appears in your UI / final load SET Sel_Implementation_COLNAME ='Implementation'; // enter the field name as it appears in the source data
SET "Sel_Customer ID" = ; SET "Sel_Customer ID"= $(od_Customer ID); SET "Sel_Customer ID_COLNAME" ='Customer ID'; /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //This section builds the WHERE_PART variables that are passed to the SUB
SET WHERE_PART = ''; // WHERE_PART to be applied to only TIM loads that contain Suffix FOR EACH fldname IN 'Sel_Implementation', 'Sel_Customer ID' LET vallist = $(fldname); WHEN (IsNull(vallist)) LET vallist = ''; IF len(vallist) > 0 THEN CALL ExtendWhere('$(fldname)','$(vallist)'); ENDIF NEXT fldname
TRACE Generated WHERE clause: ; TRACE $(WHERE_PART);
In this I have different field names in source and selection , in selection name for customer ID is ID, and in source it is customer ID, how can i match it.
