Combine columns from Dataset and tables.

chetan.c · Post by **chetan.c** » Fri Mar 23, 2012 12:17 am

Hi,
I have data like this.
Dataset,
col1,col2,col3.

Table:
tab1,tab2,tab3.

My output should be
col1,col2,col3,tab1,tab2,tab3.

There are no keys in both data on which i can join.

Please let me know if further clarification required.

Thanks,
Chetan.C

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2012 12:44 am

So what is the rule? First row with first row? Is there perhaps only one row in each source?

Without knowing the rule no-one will be able to help you.

Once the rule is known, the answer will probably involve generating an artificial key on each stream of data.

qt_ky · Post by **qt_ky** » Fri Mar 23, 2012 10:21 am

"further clarification required" = True

kiran kumar · Post by **kiran kumar** » Sun May 13, 2012 9:01 am

Hi,

I'm facing a similar situation. The only diff is, the dataset is replaced by another table.

Can you please help me in resolving this.

Regards,
Kiran Kumar

chulett · Post by **chulett** » Sun May 13, 2012 9:05 am

Please start a new post with your specific issue clearly stated.

kiran kumar · Post by **kiran kumar** » Sun May 13, 2012 9:10 am

Also, there are multiple rows in each source.

chulett · Post by **chulett** » Sun May 13, 2012 10:33 am

ray.wurlod · Post by **ray.wurlod** » Sun May 13, 2012 1:16 pm

... and maybe you are using a different version, and maybe you are running on a different platform.

When you start your own thread we'll have a better idea about your problem.

DSXchange

Combine columns from Dataset and tables.

Combine columns from Dataset and tables.

Clarification...