Assigning a Value in Framework Manager or Report Author Query

[gosoccer]

Folks,
Using Framework Manager or Report Author to get a value from a Row and apply to a different Row.

I have the following,

EVENT ID         TYPE   DESTINATION
777           21212     A           US
888           21213     B           NULL

I need to assign US from 21212 to the destination of 21213 as a part of a Query Subject in Framework Manger or
a Query-Filteration in Report Author.

Is there anyway??

Thx in advance for your time.

[Prerna Chaudhary]

Hi,

Can you please provide some more details on the requirement.

As it seems from your specification, that you just want one value to be shown for Null, so if that is the case then you can achieve the same by hard coding the value of 'US' for those rows or also use a coalesce function as coalesce ('Destination', 'US') in Report Studio


But if there is a scenario, like there is a  third row  which has data for Destination say 'UK',and other two rows with null values .Means in total you have 4 rows  with 1st one having Destination as US and Second one having destination as UK and other two rows as NULL, then how will you want to treat those NULL values.

Please let me know if you require any further information.


Thanks and regards
Prerna
-------------------------------------------------
pchaudhary@infocepts.com
-------------------------------------------------