REPLACING VALUES IN A COLUMN INTO A NEW DATA

Question

Hi, I would like to know if how to replace the values under account type column particularly the OTHER INCOME (EXPENSES) text. I want to replace the test "OTHER INCOME (EXPENSES)" into REVENUE.

From this:

G/L acctACCOUNT TYPEACCOUNT SUB TYPE1OTHER INCOME (EXPENSES)OTHER INCOME (EXPENSES)4OTHER INCOME (EXPENSES)OTHER INCOME (EXPENSES)5EQUITYTOTAL EQUITY6EQUITYTOTAL EQUITY

to this:

G/L acctACCOUNT TYPEACCOUNT SUB TYPE1REVENUEOTHER INCOME (EXPENSES)4REVENUEOTHER INCOME (EXPENSES)5EQUITYTOTAL EQUITY6EQUITYTOTAL EQUITY

Can you help me with this one please?

sazit · Answer

Hi clodelegonzales,

Similar to the solution provided above, you can use a formula tool to change your value of the field based on any condition.

For your case it seems to be the case that if ACCOUNT CLASS is "INTEREST EXPENSE" then ACCOUNT TYPE should be EXPENSE else, you should leave the value as is.

So you can create a new formula tool to update the field ACCOUNT TYPE with the following statement:

IF [ACCOUNT CLASS] = "INTEREST EXPENSE"

then "EXPENSE"

else [ACCOUNT CLASS]

ENDIF

dunkindonut7777 · Answer

Thank you for your help! 🙂 It works but there's another issue I want to ask,  how about this one:

I want to change the "Revenue" into "Expense"

From this:

ACCOUNT TYPEACCOUNT SUB TYPEACCOUNT CLASSREVENUEOTHER INCOME (EXPENSES)OTHER INCOMEREVENUEOTHER INCOME (EXPENSES)INTEREST EXPENSE

to this:

ACCOUNT TYPEACCOUNT SUB TYPEACCOUNT CLASSREVENUEOTHER INCOME (EXPENSES)OTHER INCOMEEXPENSEOTHER INCOME (EXPENSES)INTEREST EXPENSE

Emil_Kos · Answer

Hi @dunkindonut7777,

I am not an expert but for my best knowledge, the first solution proposed by @vizAlter should work faster.

I would suggest using the second option if you would have many positions that you want to replace. Thanks to that it would be more convenient for you to maintain the workflow.