on 09-14-2017 7:09 AM
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
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.