View Full Version : Nested if's or creating a fnSWITCH function

2016-11-07, 11:49 PM
I'm wondering if it is more efficient to create a column with a nested if statement or a Switch function that is built similar to the one in the guide - M is for (Data) Monkey. My data is a bank file. I have spent a day looking for ways to split a description column that contains valuable info for categorizing types of transactions. I found creating a Conditional column works the best but I have 64 possible tests. It seems a little cumbersome to write and manage.

2016-11-08, 08:45 AM
The CHOOSE function in this post should be more manageable


Rather than hard coding the conditional values you could prob maintain a table and import that.