Topic: Perform join in source data?
Perform join in source data?
Hi everyone,
I have small issue that I want to know if I can fix with DataCleaner.
I have a status code column which contains an integer. In another table (STATUS_CODES) I have status codes as well as status code types (codes are grouped in types/categories). For example:
120 -> Status OK
130 -> Status OK
200 -> Status Warning
220 -> Status Failure
-1 -> Status Failure
and so on ...
I would like to use both the status codes in my fact table as well as the status type in my analysis. Is there a way that I can make DataCleaner join the two tables so that both columns are available for me?
I have small issue that I want to know if I can fix with DataCleaner.
I have a status code column which contains an integer. In another table (STATUS_CODES) I have status codes as well as status code types (codes are grouped in types/categories). For example:
120 -> Status OK
130 -> Status OK
200 -> Status Warning
220 -> Status Failure
-1 -> Status Failure
and so on ...
I would like to use both the status codes in my fact table as well as the status type in my analysis. Is there a way that I can make DataCleaner join the two tables so that both columns are available for me?
Hi Beno,
This sounds like a scenario where you can actually use a synonym catalog based on your STATUS_CODES table and apply the "Synonym replacement" transformer to get your status category column into the dataset. It's technically not a join, but just as fine for what you're doing... it will resemble a LEFT JOIN.
This sounds like a scenario where you can actually use a synonym catalog based on your STATUS_CODES table and apply the "Synonym replacement" transformer to get your status category column into the dataset. It's technically not a join, but just as fine for what you're doing... it will resemble a LEFT JOIN.
It worked :) Thanks again Kasper.
Log in by clicking the login link at the top of the screen
Go back to forum.
