DSXchange

From looking at other posts regarding the modify stage I'm aware that there are some functions that you can use which don't appear in the documentation. Can you tell me the best place to look for a full list of what it can do? I know you can add a column with it, but can you then set that column to ...

I've working on some code where I need to sort the data on 1 set of keys, and then remove adjactent rows where some other fields have identical values... i.e. For this input data... Key1 DateKey Value 1 2007-01-04 A 1 2007-01-03 B 1 2007-01-02 B 1 2007-01-01 A I want the following output Key1 DateKe...

Thanks all,

so ...I've put a filter of 'tr '\376' '|' onto my sequential file stage

and then used the 'Field' function with a delimiter of '|' to split the field up in a transformer stage.

This should be ok in server and px.

Right, I'm convinced then. SQL it is.

Thanks for your responses.

Me, I wouldn't and would use a BI tool for that, not an ETL tool... but that's just me. I would agree, but I've been asked to produce this data into a table so that the front end developers don't have to do anything too complicated (just make it pretty and do simple selects). Good point about my la...

I'm producing a report based on the following sql select key1, key2, key3, sum(value1), SomeCalculation(value2), Avg(Value3) from MyTable group by cube key1, key2, key3 If I instead just brought back the basic rows from the database (without the group by cube and the calculations), how would I recre...