Finding Not Null from multiple columns & outputting records in a new column

[kushalb]

Hi, I am trying to use P_CLASSIFICATION & C_PI CLASSIFICATION data to fetch a correct Classification in a new helper column for Data Mapping through IF Formula in Formula tool but I couldn't do it

Kindly help me with the solution on this as how to navigate this. (Might be concatenate would not work here because of formatting issue but have not tried that though)

Number	CLIENT NAME	P_CLASSIFICATION	C_PI CLASSIFICATION	Correct Classification
1000354	ABCD	IPZ	CZW (Full)	IPZ + CZW
1002156	EFGH	IPZ	NULL	IPI
1015	JKLM	IPZ	SFW	IPZ + SFW
1028	NOPQ	IPZ	CZW (Partial)	IPZ + CZW
1048490	RSTU	NULL	CZW (Partial)	CZW
1059096	VWXY	NULL	CZW (Full)	CZW
1029	FGQA	NULL	SFW	SFW

[chukleswk · Accepted solution]

You can use the following formula using the formula tool:

if isnull([P_CLASSIFICATION]) then trim(getword([C_PI CLASSIFICATION],0))

elseif isnull([C_PI CLASSIFICATION]) then trim(getword([P_CLASSIFICATION],0))

else trim(getword([P_CLASSIFICATION],0)) + ' + ' + trim(getword([C_PI CLASSIFICATION],0))
endif

 

[kushalb]

Thanks for solving that very quick