Fields that are called ID

tabitha shared this question 19 months ago
Answered

Morning,


when i select the table of infromation some of the fields are called ID. Which then gives them numbers instead of what the title is stating. An example:


I want to see all the categories the organisations are assigned to but i only have a category_ID as an option to pull accross into my record.

Can i create a calculated field that will change this so the titles appear not the numbers please? If so how?

Comments (7)

photo
1

Hi Tabitha,

Thanks for reaching out with your question. While the answer to your question can be somewhat data-specific, I'm guessing that your "ID" field is in actuality a foreign key which relates the table in question to another table.

If you were to create this join in your View, you could forgo using the ID itself, and instead use the related record from another table.

Here's an example of this:

I have a table, 'Component', which has the following fields:


bc500f8424106300e835a7d499175ece

I have in this table, 'LICENSE_ID'. This field is of a numeric value. What this numeric value represents is the primary key of the 'License' table:

521a9764d8e988ea6c349d0c1e7f21de

This table also includes the text name of the license. What I need to do is join these tables together in order to display the actual text value in my reporting.

In this case, I'll do an INNER JOIN on the tables WHERE 'COMPONENT'.'LICENSE_ID' = 'LICENSE'.'ID':

6ec907b0db452f6c9f81ffc8e75050a3

This will allow me to use the 'LICENSE'.'NAME' field instead of the 'COMPONENT'.'LICENSE_ID' field:

6df088a6b51c02c6250c005e8b6b0b1b

This would be your best option in translating the ID to the appropriate field. If you're unsure as to whether this is an option, your DBA may be able to assist.

If you have an ID field that is NOT a foreign or primary key, it is possible to use Org Reference Codes for this field. This will allow you to convert specific values to other values. More information on setting those up are available here.

Let me know how it goes.

Thanks,

Ryan

photo
1

Hi Tabitha,

I wanted to check in and see if my reply has helped.

Thanks,

Ryan

photo
1

Hi Ryan,


thank you for your response. I got stuck at the first hurdle as I couldn't find the table options that your screen shows.

photo
1

Hi Tabitha,

This area will be accessed at a View level. If you do not have access to View editing, I recommend contacting your local IT Administrator or DBA. More information on View Management is available here. While in the View editor of the View you're working with, you should see the View Builder screen:

10f296c5e960b6b428f0fb8be6081225

The left pane is a list of tables you can add to your View. Clicking the gear icon on the table(s) added to the canvas will give you the right hand pane where you can choose your columns.

I also would like to recommend some of the 'IT Admin Data Administrator' courses available for free on our Yellowfin University if you are tasked with creating Views for your report building.

Does this help?

Thanks,

Ryan

photo
1

Hi Tabitha,

I wanted to check in and see if my reply has thoroughly answered your questions. If I don't hear back I'll presume this is the case and mark this as Answered.

Thanks,

Ryan

photo
1

all good here. Thank you

photo
1

Hi Tabitha,

You're welcome! Please don't hesitate to reach out with further questions or issues.

Thanks,

Ryan