01-28-2018 05:52 PM
I am unable to get Max or Minimum dates from a dataset in DI Studio in a Extract node.
In Di Studio (Version 4.901) I try this in an Extract node and gives an error "Summary Function restricted to Select clause" etc.
The expression is; catx("_",(min(intnx('Month',(Datepart(Policy_Period_Create_Time)),0,'E')) ),Account_Number)
However the same expression runs correctly in SAS EG.
Appreciate any help here.
01-28-2018 06:21 PM
The error message isn't about the expression itself. It is about where in the query you used it. Give more détails, please.
01-30-2018 03:31 AM
I am creating DIS reporting job, in the process I have to select the minimum effective date (month) group by account ids (and creating a unique Id with the effective month and Account ID).
So I created this in SAS EG and all worked fine, however when I re created this step in DIS the error was given and couldn't go beyond.
Attached a screenshots of the Extract Mapping hope this will help.
01-30-2018 09:30 AM
I need to see the full mapping tab, and the full generated code for that step.
01-29-2018 07:28 AM
Please show the generated code, and potentially screen shots on relevant transformation tabs.
01-30-2018 03:43 AM - edited 01-30-2018 03:51 AM
The DIS Code is given below , I am creating an ID with minimum date and Account id, so unable to execute the minimum date expression in DIS in a extract transformation, however the code works in SAS EG.
create table work.Subsequent_Quotes_0 as
Period_Created_Month length = 8
format = DATETIME22.3
informat = DATETIME22.3
label = 'Period Created Month',
(catx("_",(min(intnx('Month',(Datepart(Period_Create_Time)),0,'E')) ),Account_Number)) as Account_Policy_ID length = 8
label = 'Account Policy ID',
Need further help from the community? Please ask a new question.