If Then Statement in Data Load Editor

[fslavov]

I want to be able to create a new field from 2 fields based on certain criteria. For example I have 2 columns below: 

Description| Category
200ABC|A
DEF|A
100GHI|A

If Desription field containts a number then create a new filed (e.g.Description and Category) and combines the number 200 with Category A so output should be 200A 

[MayilVahanan]

Hi 

Try like below

LOAD KeepChar(Description, 0123456789)&Category as Category, PurgeChar(Description, 0123456789) as Description INLINE [
Description| Category
200ABC|A
DEF|A
100GHI|A
](delimiter is '|');