At the moment I had to deal with a special problem. I have data in a SPO from two different sources and the goal was to find the corresponding two data lines and make one out of it. This line should marked with a special character. So I decided to build an Analysis Process (APD).
Open the transaction rsanwb and create a new Analysis Process. Now you can choose between different data sources for example Multiprovider, Query, Flatfile or Database Table. In my case I choose a Query that delivers me the last loaded request, so that I don't have to read the whole SPO. If this works in the future we will see, but the first developer test were successful.
After the query receive the data, I build an aggregation with the function Aggregate Data. So, I made out of two records one record. Which record is from which source, I add the same query again as source and restrict the data to one source system. Now I use the Join Data function to join the source system with the aggregated data. I did the same with the other source and joined it again with my data from the aggregation.
So now I have my data in the following format:
So now I can check with a formula if both (SOURCE_SYSTEM1 and SOURCE_SYSTEM2) is filled or only one. If both are filled, I add another column (SOURCE_SYSTEM3) with S3 or I filled in one of the values of SOURCE_SYSTEM1 or SOURCE_SYSTEM2. It looks like this now:
Now I can hide the two columns (SOURCE_SYSTEM1 and SOURCE_SYSTEM2) and have only left the necessary columns for my DataStoreObject. So I find a corresponding record I can reduce my data amount but still keep the granularity of the data. Maybe there are different options to do this procedure. If you have any suggestions, feel free to use the comments.
These posts might also be interesting: