Hope the attached workbook can be of help to you. And in case you can't open the file as its on version 10.4, refer to the screenshot below.
Data is like
Column 1 Column 2
You can add more conditions to the if statement based on your requirement- just remember that the data type should be same.
Note: Please mark if this resolves your issue so that others can benefit from it. Happy Learning & Holidays!
Combinestrandinteger.twbx 14.2 KB
Maybe the method described here can help:
The IFNULL function returns the first expression if the result is not null, and returns the second expression if it is null.
Hi Swaroop - the function will work for same data type but in case it has string and integer which I assume is the case (based on the example given), the data type needs to be changed for one of the field.
Using your method, IFNULL(dimension1, str(dimension2)) - assuming dimension2 is integer
Sorry I'd replied not realizing you had already.
That's a good point to add the STR in the calc.
No worries Swaroop, its always good to know all the alternatives.