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.
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
-------------------------------------------------