Lookup Override

[aravindv26]

Hi all,

In my mapping source is a flat file, in that i have a field called lastdateofqtr using which i am looking up into one
table and finding out fiscal quarter, then i want to fetch Min(Today) and Max(Today) from the table using lookup
and passing fiscal quarter. Using min and max values of today i want to delete the rows in a table, such that postdate in the lookup table lies between these min and max dates.

Here i am lookup overriding and want to get the max and min values but i am getting the error as lookup not found,
and for the lookup override for delete statement it says: Invalid lookup override.

Any suggestions are welcome....

Thanks in Advance...

Aravind.

 

[blom0344]

Did you try and create aliases for the aggregate objects, like:

Select Min(Today) As Minvalue,Max(Today) As Maxvalue from ....

What will always work is storing the override SQL in a view and then addressing the view without override ...



Ties Blom
Information analyst