Forum Discussion

eacy's avatar
eacy
Helper II
9 years ago

Execute user function per row or group

Hi,   I have a table with dates and I would like to add a new date row for each month since the first create date until today for each issueid. I have created a user function which will genereate ...
Need Help
eacy's avatar
eacy
Helper II
9 years ago

Hi Bhavesh,

 

I want a table like this one.

 

this one contains one row for each month since the creation date for this specific issue id (225389).

 

My problem is the user function is only executed one time for the first issue id in the original table. I would like to executed it one time for each of the issues in the original table.

The business case is that i want to ensure that I have at least one entry per month per issue id. I have arount 1000 different issue ids

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

eacy

As I can see from your M code that you are only filtering the records to get the values of that particular record. 

 

What user function are you using?? SYNTEX and other details. Posting a Sample data file can help me to demostrate you the different ways. 

 

It is really confusing to follow the M codes with limited data available.