Skip to Content
avatar image
Former Member

How to force distinct result from Data foundation table

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,


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers