Adding two different values from different quesries.

[Former Member]

In Visual Composer:

I have two different queries of BI. I want to take one value from query -1 and display in one column. Another value from query -2 and want to display in another column. Then I would like to add both values and display the added value in one column.

How to approach this scenario? Is there any sdn guide available?

Thanks,

Padman

[Former Member]

Hi ,

First take those input fields into a Table .

Use the Combine Operator to combine them in a Table.

Add a third field to the combine table of numiric type .

In the Expression field of third field put : Field1+Field2 .

Thanks,

Govindu

[Former Member]

Hi,

I haven't done anything in VC. Is there any help document or guide available for this scenario?

Thank you,

padman

[Former Member]

Dear Govindu,

Isn't it the case that the combine operator only displays the result from the first query? I am struggling to get results from two different data services into one single table and I was told to use the Union operator, but I still have some troubles to configure that.

Best regards,

Jan

@Topic starter: Check the Wiki for Visual Composer:

https://wiki.sdn.sap.com/wiki/display/VC

Please award points if helpfull.

[Former Member]

Hi,

Follow Below Steps You Will get F3=F1+F2 For All Rows.

1) Drag the first query data to dash board output node to the tables form ..

2) Next drag the second query data into dash board and output node to the table form .

3) Now drag the the first outputnode query to filter data input node .

4) And next similarly second query output node drag the outputnode to second filter input node .

5) Finally filter 1 , filter2 output node to union operator from there u drag to table input node .

6) Just click on union operator u can see list of the fields from two tables select f1 it will appear like (rightmark) and simlarly select f2 .

7) now u can create f3 variable of type number in form . and goto properties tab click on general go to formula

take your two fields from data fileds like this f1 + f2 . check your formula .

😎 finallly select one key field in union operator .

now deploy and comile u will get the following output

Follow Above Steps If need revert back to me.

Thanks

Subbarao Chinta