Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
my requirement to get distinct value from two columns. i need this in dimension expression
lets say my data rows will be look like this
Id | Originstate | DestinationSate | |
---|---|---|---|
1 | PA | VA | |
2 | PA | TX | |
3 |
| NY | |
4 | FL | MA |
Finally i need data look like below as single value in expression
ex:
state |
---|
PA |
VA |
TX |
NY |
FL |
MA |
please advise me how to get this
You can follow the idea presented in
It doesn't really matter if the field is holding dates or states, just create the link table as described.
i tried it but its showing syntax errors
How to write that in expression not in edit script
I (strongly) recommend that you prepare a link table in your model.