Hi,
Lets see I have this sample data listed below:
studentId|studentName|studentAge|studentCity|studentSubject|studentDeptId|studentDept|studentEmail|studentPostalCode
1001|shiv|32|chandler|history|1031|tenth|shiv@abc.com|85032
1002|sathish|31|phoenix|physics|1041|sixth|kaubc123.com|987
1003|yaswanth|24|phoenix|maths12|1051|fifth|vijay@234thh|85027
I can have duplicate records, duplicate rows for above data but the combination of "studentId + stduentName" should be unique.
I have Talend Enterprise Version(subscription) and I am using Talend Data profiling.
I would like to know how I can perform any kind of "Analysis" to create this combination and run profiling on this? I did explore "User defined indicators" and "Custom Regex Patterns" with no success. Can you please suggest solution/work around to achieve this?
