Join/Combine/Merge BI Query and JDBC Datasource resultset into one table

[benjamin_houttuin]

Dear Guru's,

We currently face the following issue:

We would like to combine a resultset coming form a BI Query and a resultset coming from a JDBC Source into one VC Table.

The BI Query returns 20+ columns and the JDBC 3 columns.

Both return a column that contains the Year.Month combo, this is our key that we would like to join on.

Is this possible? We tried al Operators but cannot get the columns in...

Writing a custom SQL statement via the SQL editor on the JDBC source is also not an option as that lets us only adress the columns from the JDBC source and not the BI Query.

Any Ideas? ( preferably ideas that do not involve JAVA or ABAP programming )

Cheers,

Benjamin

[Former Member · Accepted solution]

Hi Benjamin,

Unfortunately, what you are trying to do is impossible...

You want to join two tables, but VC doesn't support the join function.

You will have to perform the data manipulation (in this case, join) outside of the VC scope, I'm not sure how, but definitely not in VC.

Thanks,

Udi

[benjamin_houttuin · Accepted solution]

Thanks Udi,

We thought so but confirmation is always great.

Cheers,

B.