Forum Discussion
Solved
How to handle very complex IF statement
Hi there, Here is my problem: I have form that submits values into a table which is then used as my data source. This form has 50+ variables and not all of them will be filled in in any one s...
Thanks v-easonf-msft and amitchandak for your responses.
The way I have ended up doing it is to instead use if statements that look for blank values, and if it's blank then to show nothing (""), if theres a value then add it in. For example
Combinevalues(" ", If(isblank([v1]), "", "V1: " & [v1] & unichar(10) & unichar(10)), If(isblank([v2]), "", "V2: " & [v2]& unichar(10) & unichar(10)) etc. )
This is working to meet my needs, I just had to repeat it for each column in my calculated column
Hi , Hayleysea
As mentioned by amitchandak , you can use function "unpivot" in query editor.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.