BLS

[former_member1111248]

hi,

There are three sql queries,the output of each query has two columns(Date and Value).the 3 sql queries give different values for a particular date say(Aug-07).can anyone say me how to add the values of the three queries for a particular date(Aug-07)

thanks

karthick

[Former Member]

Use the Crosstab BLS action block.

[former_member1111248]

Hi

i tried out joiner to join the first two SQL outputs and then used another joiner to join the output of joiner with the third SQL output.its working fine now....

thanks,

karthick.

[Former Member]

Glad to see you figured it out on your own!

However, please remember that there will be some issus with the Joiner if in the event there are null values, which is why i asked the question i did in the first post.

If you are satisfied with the current fix then so be it. Otherwise can you please answer the question i posted previously, so that we can explore all resolutions?

[former_member1111248]

hi,

Thanks for your reply,actually the three XML outputs are from the same SQL query but for for different sets of parameters,here i am using the outer join and it is bringing the null values also......

Thanks,

karthick....

[Former Member]

Are the 3 queries from diff systems? Or is it the same database?

If so, it would be much easier to retrieve all three values in ONE query. Otherwise, just use a little XPATH magic to navigate to the node for your desired date, extract the values and perform your calculation.