How to link specific rows

Hi all,

So I'm trying to link specific rows to each other. I've attached a screenshot. As per the screenshot I would like for every Inspection and Audit_id a corrosponding row of Audits & Findings from the Category column. What tool should I be using for this?

Cheers.

Doc1.docx

Workflow

Accepted answers

Dazzerman

Hi again @Saim,

Depending on the shape of your data, there are different ways to get rid of the duplicates. The question is what rules to use to remove the duplicates. Most likely you can use a Unique tool, specifying key fields to eliminate the duplicates, but a Summarize tool can also be helpful in some circumstances.

If you still get stuck, maybe you can share a spreadsheet with extracts of the two datasets and we can take a look at the best way for you.

All comments

JoeS

Hi @Saim

It looks to me you have unioned the data together?

If you want the rows to be next to one another you will need to join them on a value. Is there a common value across the two sources?

Dazzerman

From what I can see from your data, it looks like you should be joining the Zone field from your first dataset to your Zonee field in the second. Give that a try and see if it moves you forward.

Saim

Yes its a union. So the grand idea is to make an image with coordinates in Tableau with this as the datasource. Each Zonee column has 3 coordinates that's why when i use the common value Zone to join them I get duplicate values. So i figured I'd use a union and afterwards somehow relate the data. The important thing is that all the Inspection/Audits get a coordinate and I don't get duplicates

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703