SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Adding Having clause inside Extract node without adding it inside the user written code

Reply
Learner
Posts: 1

Adding Having clause inside Extract node without adding it inside the user written code

Hi everyone!

 

I am currently using SAS Data Integration version 4.9 for data management. Is there a way to add a having clause inside the extract node without changing the code inside the user written code tab? 

 

Thank You in advance!

 

Super User
Posts: 5,430

Re: Adding Having clause inside Extract node without adding it inside the user written code

Not really, and I have asked for a having tab int the transformation...

But, you could use the SQL Join transformation for this, so it should be no brainer. Even if it's called Join, it doesn't have to be a join, just remove the second input - and for clarity, add/change the transformation description.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 394 views
  • 0 likes
  • 2 in conversation