How to view unique combination of columns in Talend Data Profiling/ Talend Data Quality

[Anonymous]

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?

[Anonymous]

Hello,

Could you please also elaborate your case with an example with expected output values?

Best regards

Sabrina

[Anonymous · Accepted solution]

I found my answer in "Column set analysis"

Thank you for your time and efforts 🙂