Skip to Content
0

How to force distinct result from Data foundation table

Sep 14, 2017 at 06:09 AM

15

avatar image
Former Member

I am using Information design tool version 4.2 ,

and I insert a view ( ex MyView ) from Teradata in the Foundation layer , I want to force Distinct result to be returned whenever the user drag any column,

Example

If user drag Col1 from this view, the generated query should be

Select distinct Col1 from MyView

If the user drag col2 from this view , the generated query should be

select distinct Col2 from MyView

I have tried to use derived table , and make the new table to be select distinct * from MyView. But the resut was not correct

If the user drag Col1 from the derived table, the generated query will be

Select Col1 from ( select distinct * from MyView )

I also try to write Distinct in the select definition in all column , but it also fail ,

If the user drac col1 and col2 from the view

The generated query will by

 ( select distinct col1 , Distinct Col2 from myView) 

Which is not correct

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers