GSA 5.2.11 "Do Loop" within Analysis ("dynamic" Join?)

[Björn Schaefer]

Hi there

Maybe there is an easier way by doing the following step by step:

I have a given AnalyticObject Table like this:

This AO contains some columns with Numbers (Auftragsnummer Strom, Gas, Wasser, Wasser öffentlich), representing ERP Order Numbers (in our case kVASY,)

What I want to do now is:

For each AO row shown above I'd like to search the ERP Table "Auftraege" with those given Numbers to sum up booked costs onto those Order Numbers . As you can see, not every row has all columns filled, so sometimes it would be necessary to aggragate a single Ordernumber, sometimes I would have to to this up to 4 times.

I know, that I may build a construct with a single Join onto "Auftragsnummer Strom", which results in another AO Object. Using the new AO, create a new Join with Auftragsnummer GAS, and so on.

Is there any possibility to do something like this more dynamic?

thanks in advance for your time

 

[markvanderhurk]

Hi Björn,

I don't have a solution within GSA directly (although there might be, maybe some of my colleagues know) but I might have an option as a workaround. What kind of feature source are you using for this? If it is a kind of database access, you might build your query (giving you intermediate results) in SQL and use the result as a source table in GSA.

Cheers, Mark

 

[Björn Schaefer]

Hi Mark
Yes, the requested Datasource is a database (oracle). Unfortunately, I'm no SQL Coder.... but:

Rethinking that problem some times, I found an easy way to solve this:
there can be more than one condition for that desired join, so i added some OR Statements


Sometimes solutions are way to simple