I have loaded a manual file on qlik and I need to use the data loader to make some additions in the data I have.
Suppose I have a start date and end date of an application or if its still ongoing, I'd like to add columns for each month on master data from Jan 2017 to current month(dynamically to add column for each new month from there on) and enter flags for all the months it's ongoing. Ex: if a file was open for Jan 2017 to April 2017 and this is the month of May 2017. I need to add columns: Jan, Feb, Mar, Apr, May and the values for that file should be 1, 1, 1, 1, 0.
I've attached an example file below for the input I have and output desired in two sheets.
Hello @vinieme12 , I updated the question because I think it wasn't clear as to what I needed. I basically want to set a flag in which a set of applications were created and being worked upon until the last stage and mark them as 1 for each of the application based on the months they were open. I have the start date for those applications and end date for only those that were finished, rest are ongoing, I also have status, but they just tell their current status which is of no use in this problem. Could you suggest how do I solve this?
