accessing two data sets from a single table

hi all
i have a large amount of data which has to be shown in atleast 40 columns and 10 detail rows of a table.
And this is going to come from two data sets..(thats for sure)...
i map the result columns from dataset1 to columns in the table taking the table binding to dataset1....
when i again drag n drop the columns from dataset2 to other columns its not working....

can i have an option to bind both the datasets to the table?
is it possible with the data sets joining?

thanks in advance

regards
krishna chaitanya.

Find more posts tagged with

Comments

chaitanya

hi all

i have created a full outer join of the two datasets..i did the table binding to the new joined dataset..
i am unable to view the coulmns in the joined dataset in the data explorer..
if i view them i hope then only i can drag and drop the coulmns in both the data sets onto the table...

thanks in advance

regards
krishna chaitanya

mwilliams

Hi krishna,

You've joined the dataSets and cannot see an output now? Is there no common key between the two dataSets that you were able to join on?

chaitanya

hi williams

please have a look at the screen shot i am attaching...i do have student_id as the common column..i have created a full outer join on them..in the preview results of the join creation i can see all the columns of both of them..
but when i go into the data explorer and open up the joint data set. i cannot view any and so i cannot drag n drop the columns..

regards
chait

mwilliams

Hi chait,

Is there any way you can recreate this issue with the sample database? I'm not sure just by reading what the issue is.