Splitting Data

Discussions about editing and cleaning data
Posts: 7
Joined: June 26th, 2017, 2:15 pm

Splitting Data

Postby manishcspro » July 17th, 2018, 3:12 pm

My data entry application stores data for a quetionnare from month april to march in a financial year. I want to create a menu program to Split data files into seperate month based on parameter pased in menu item. Setoutput function seperates all the data into different months. But i want to seperate only cases which is selected in menu program. I also used sysparm function to create parameter in batch pff but it seperates all the cases in data files.Please help me out with example.

Gregory Martin
Posts: 1037
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Splitting Data

Postby Gregory Martin » September 10th, 2018, 9:57 am

It will be easier if you post your code so that we can see what you are doing and why it might not work.

However, this could work if you want to split a single month of data to a file:

if MONTH <> tonumber(sysparm("SELECTED_MONTH")) then
    skip case;

Return to “Editing”