Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Data Set question
Migrateduser
Hi,<br />
This is probably an easy one for you guys. But i am quite a newbie and still learning on the fly.<br />
The data source is an xml file. I have a data set named "Test". It has 3 columns from that xml source file. It also has 1 computed column which is derived based on those 3 columns and conditions. That computed column obviously has "repeated" values. Now, i want to create or derive another data set which will just have one column which contains the "unique" set of the above computed column. kinda like select disctinct(column) from table<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>Result of Test Data set
Col1 Col2 Col3 Col4(Computed)
03 1D 1DX
02 1D 1DX
A 1E 1EY
B 1I 1IY
DA 70E DAH 70EDAHZ
BA 70E DAH 70EDAHZ
Result of "New" Data Set should be like
Col1
1DX
1EY
1IY
70EDAHZ</pre>
Find more posts tagged with
Comments
There are no comments yet