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
Combine columns from Dataset and tables.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 25
- Joined: Wed May 02, 2007 1:07 am
Clarification...
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
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
-
- Participant
- Posts: 25
- Joined: Wed May 02, 2007 1:07 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... 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.
When you start your own thread we'll have a better idea about your problem.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.