Hi All,
I need your help to implement a logic:
I am having source data like this
Col1 Col2 Col3 Col4
ABC/001 E0101 ABC/001 E4031
ABC/001 E0101 ABC/001 E15399
ABC/001 E0101 ABC/001 E022
ABC/001 E1360 ABC/001 E0101
ABC/001 E4031 ABC/001 E022
ABC/001 E5941 ABC/001 E623
ABC/001 E5941 ABC/001 E0101
ABC/001 E5941 ABC/001 E022
ABC/001 E7539 ABC/001 E022
ABC/001 E186 ABC/001 E4031
I want to update Col3 in such a way so that no inter-patching will be there. I don't want to update all values in col3. I want min updates in col3. as of now these records represents links between col2 and col3 for same building ABC/001 I want to create minimum no of new buildings so that there is no link between same building.
Please provide your inputs. This will help me.
Regards,
Prashant
Need to divide data in groups
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Wed Oct 06, 2010 11:24 am
-
- Participant
- Posts: 35
- Joined: Wed Oct 06, 2010 11:24 am
The output should be like this:
Col1 Col2 Col3 Col4
ABC/001 E0101 ABC/001_2 E4031
ABC/001 E0101 ABC/001_2 E15399
ABC/001 E0101 ABC/001_3 E022
ABC/001_2 E1360 ABC/001 E0101
ABC/001_2 E4031 ABC/001_3 E022
ABC/001_2 E5941 ABC/001 E623
ABC/001_2 E5941 ABC/001 E0101
ABC/001_2 E5941 ABC/001_3 E022
ABC/001 E7539 ABC/001_3 E022
ABC/001 E186 ABC/001_2 E4031
Here I have break up the one building into three buildings by two updates(two new hypothetical buildings) In this output there is no link between same building all are divided
Hope this will give u the picture of inter-patching.
Regards,
Prashant
Col1 Col2 Col3 Col4
ABC/001 E0101 ABC/001_2 E4031
ABC/001 E0101 ABC/001_2 E15399
ABC/001 E0101 ABC/001_3 E022
ABC/001_2 E1360 ABC/001 E0101
ABC/001_2 E4031 ABC/001_3 E022
ABC/001_2 E5941 ABC/001 E623
ABC/001_2 E5941 ABC/001 E0101
ABC/001_2 E5941 ABC/001_3 E022
ABC/001 E7539 ABC/001_3 E022
ABC/001 E186 ABC/001_2 E4031
Here I have break up the one building into three buildings by two updates(two new hypothetical buildings) In this output there is no link between same building all are divided
Hope this will give u the picture of inter-patching.
Regards,
Prashant
-
- Participant
- Posts: 35
- Joined: Wed Oct 06, 2010 11:24 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 35
- Joined: Wed Oct 06, 2010 11:24 am
Hi Ray,ray.wurlod wrote:Are these (this one and the "infinity rings" one) theoretical, or are they solving some real-world problem (and, if so, what problem)? ...
These are solving real-world problem. I cannot share the details publicly. Please share your details(private mail id or anything) so that I can let you know the real world problem but not the original data.
Apologies, but I hope you can understand.
Thanks for responding and trying to solve my problems.
Pacific
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: