Need to divide data in groups

Pacific007 · Post by **Pacific007** » Sun Apr 10, 2011 5:46 am

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

chulett · Post by **chulett** » Sun Apr 10, 2011 7:45 am

Please post an example of what your desired output would be for the input you posted. Seems to me that would help explain whatever "inter-patching" means.

Pacific007 · Post by **Pacific007** » Sun Apr 10, 2011 8:22 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

Pacific007 · Post by **Pacific007** » Tue May 31, 2011 5:08 am

Can anyone help me on the above issue.

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2011 6:41 am

Are these (this one and the "infinity rings" one) theoretical, or are they solving some real-world problem (and, if so, what problem)?

Pacific007 · Post by **Pacific007** » Tue May 31, 2011 11:01 am

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)? ...

Hi Ray,

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 31, 2011 5:08 pm

There are PM and email links below every one of my posts.