Forum Discussion

gittelena's avatar
gittelena
Microsoft Employee
6 years ago
Solved

Replacing default values

Hi there,   I am getting my data set via a API URL and need to change some default value codes (e.g. 0=Active, 1=Resolved, 3=Cancelled etc.)   I can think of 3 ways to do this:   1: Replace the ...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    For 3 values, a conditional column (basically nested IFs) will work great.

    If it is more than that, you might want to create a reference table then merge that with your imported table, sort of like getting the item description from an Item DIM table to add the description to your FACT table where only the item number exists. You can do that hundreds/thousands/more rows were a conditional column would be impractical.

edhans's avatar
edhans
Community Champion
6 years ago

For 3 values, a conditional column (basically nested IFs) will work great.

If it is more than that, you might want to create a reference table then merge that with your imported table, sort of like getting the item description from an Item DIM table to add the description to your FACT table where only the item number exists. You can do that hundreds/thousands/more rows were a conditional column would be impractical.