How can I create a new field from existing data in the Data Load Editor?
I am loading an Excel file from SharePoint with around 50 columns of data and around 7,000 records. One of the data fields is named 'Fiscal Year and Quarter' and contains 11 characters, ie 'FY2015 Qtr3'.
I need to extract just the first 6 characters from this field, ie 'FY2015', and not the Quarter, and I want to create a new field named 'Fiscal Year' containing these 6 characters.
Can someone please let me know how I can set a command in the Data Load Editor to do this?
Re: How can I create a new field from existing data in the Data Load Editor?
I’ve tried to do that but I cannot find an option to allow me to mark it as answered correctly. When I click on ‘Actions’ at the bottom of your mail in Qlik Community, a box pops up saying ‘No actions are available’ and I cannot see any other way to mark this as answered in the Discussions Forum.