This content has been marked as final. Show 6 replies
I have a field called 'Narrative', Within this field are loads of descriptions (See attached spreadsheet)
What i want to do is group them together and rename them.
All descriptions starting with 'Goods ' to be renamed 'Goods Received'
All descriptions starting with Stock' to be renamed 'Stock Check'
I know how to do this within the application :
=IF(UPPER(Narrative) like 'Stock*','Stock Checking' ,Narrative)
but i want to do it in the load script. Can anyone tell me if it can be done please?