Conditional Format of Colum Results

HI Community -- I have a column (text) that returns either a value off 1 or 0 . but I want to create a column that actually creates the corresponding value . For instance is the value is 1 then its Direct otherwise is Fund.

Fund or Direct	New Column
1	Fund
0	Direct
1	Fund
0	Direct
0	Direct
1	Fund
1	Fund
1	Fund
1	Fund
1	Fund
1	Fund
1	Fund

Accepted answers

All comments

JensitSebastian

Hi lennylong0630,

This can be achieved by simple IF THEN ELSE statement. You can define a list i.e Fund Type with two list items as 1. Fund 2. Direct. The 'New Column' line item format where you write the condition should be list (Fund Type). Then using line item "Fund or Direct" write the condition. IF Fund or Direct = "1" THEN Fund Type.Fund ELSE Fund Type.Direct

Note: You have mentioned that 1 and 0 are in a text field so use double quotes " " while matching the condition.

And by defining a list you can refer and reuse the classifications anywhere in the model.

Hope this helps you.

Thanks,

Jensit

ankit_cheeni

Hi @lennylong0630

This might seem like a simple task but the complexity can be increased to explore other options.

The simplest method is to create an IF statement where IF Fund or Direct = "1" then "Fund" Else "Direct"

Here, we are assuming Fund and Direct to be texts (and the New Column to be text formatted). If Fund and Direct are list items, you'd want the line item to be list formatted and create a list that has a code 1 to Fund and 0 to Direct. This will allow you to use FINDITEM without any hard coding.

Let me know if some other use comes to your mind.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…