Derive format of a date field based on country column
I have two columns in my QVD, country and date. I am persisting my data into a straight table, now I want to have the format of the date to be dependent on the country value of that row. How is this best achieved?
Using the if clause to derive the value in edit script
using calculated dimension to derive the format of the date
using an expression
P.S.: There are around 10 date columns present which are supposed to be formatted