One record for data with different calue in one specific field

Question

Hi Everyone,

Currently my data is presented in the following format:

ABC             7.5                    HIGH                     123

ABC             7.5                    HIGH                     456

ABC             8.5                    HIGH                     123

ABC             8.5                    HIGH                     456

The issue is that I joined data from two files and in one of those files, Title ABC has two different ID's so it is creating multiple records for one score. Is there a solution to this so that only one record with the same Title is displayed but encompasses both ID's in one record. I am guessing I will have to create a second ID field but just curious to see if there is another option. Any ideas will be greatly appreciated! Thanks.

Thableaus · Accepted Answer

Hi @Chirag_Gandhi07

You can concatenate your ID field with Summarize Tool

Then if you prefer you can split this field into ID1 and ID2 with Text to Columns tool.

See flow attached.

Cheers,