I'm working on a IF statement
Here it's what I have
iif([Day])="D-WK", "Sun"
If the col Day = ])="D-WK", give me Sun under a new col named Sunday
it creates a seven day look Sun,Mon,Tue,Wed,Thu,Fri,Sat
Sun
@Primus wrote: Hi Charles the code worked is there a way to do the same thing but create a new col for each day of the week ? for example after the adding the formula I get this
Hi Charles the code worked is there a way to do the same thing but create a new col for each day of the week ? for example after the adding the formula I get this
Does "the code" mean the if statement in my reply, or the workflow? In the workflow I attached, the columns are created with a CrossTab tool. I just want to make sure in case the workflow was unclear.
Hi @Primus
It seems like you're asking about a day name formatting question ("Sun" to "Sunday") and a data transformation question (Field [Day] to new fields?). Could you provide an visualization to show the Community what you're looking to do? I'm sure it would help get you the response you seek.
The data looks like this
Id order date
abc D-WK-M
123 D-WK-Tu
I would like it to look like this
Id order date Monday Tuesday Wednesday Thursday friday
abc D-WK-M Mon
123 D-WK-Tu Tue
345 D-WK-Fri Fri
