Data Services Cleansing Error...........

[DayaJha]

Hi .......

Guru's.............

I Was Facing a issue When i Execute the Job in Desginer Window

Error: [EIM Transform Source:NameAddress_Match]

Option Group Error(Option Group: Data Collection Config 😞 The SECONDARY_SOURCE_COLUMN_NAME option and the BREAK_KEY_COLUMN_NAME option in the DATA_COLLECTION_CONFIG group cannot both be disabled because the ENABLE_CANDIDATE_SELECTOR option is enabled (BODI-1116087)

Thanks,

Daya Shankar Jha

[Former Member]

Below is the Source data, which has complete address in one single column, however Client wants

this address column into 3 columns as Add_line1, Add_line2, Add_line3....

Would somebody please help me...on this

This Address has different formats: For example…

1. 1. Few address has ‘,’ COMMA separated
2. 2. Few with SPACE separated
3. 3. Few with NOTHING

Nos	Source
1	55444, 212th Main, ITI L/O Mallathahalli Bnaglore-42145
2	18446 B,Ranka Colony,Bilekahalli,Bannarghatta Road,Hyderabad-143121
3	#301, 65th main, 125th Cross, Cross extension, Vivek Nagar,Hyderabad-874545
4	Plot # 542,BHS Layout,101th A Cross,184th Main,SanthnagarBommanahalli,Bangalore-1245454
5	#0542427, GF, 24540th Main,455th Cross, Sector 1, HSR Lay Out,Hyderabad-624515
6	King Apartment, Sumana Nagar, Near 5454 Main Hospital, Vijay Nagar, Marol-Mahroshi Road, Andheri East, Hyderabad 400059.
7	Residency Jet  Mumbai,Opp. Techniplex Compamy Off S.V.Road, Goregaon (W), Pune
8	Pop & Ben Corporate Stay,B706, 107th Floor, Joy Valencia.Near Majas Bus Depot Jogeshwari East Thane
9	Sao Ashok Nagar, Borla, Govandi Hyderabad 400088
10	Plot No.54534/6Yet Home Colony Opp.Of Maharaja LightKarvenagar
11	Room No.2orgage ColonySr.No.487/8DAzadwadiKothrudHyderabad545745
12	Sr.No.14352/149454Building No-202Ajmera ColonyPimpriHyderabad-411018