How to implemente ODAG into multiple tables ?

[aresb]

Hi all,

I'm stuck in a problem with ODAG.

Let's assume I have two dimensions tables, A and B, with this structure:

A
column1, column2

B
column3, column4

When i write down the $(WHERE_PART) condition into the ODAG SCRIPT, i put the script "For Each fldName in 'column1' and 'column4'".

After this, i write down into the template app $(WHERE_PART) both into A and B QVD's.

The problem is that, indeed, script goes wrong since where condition takes into account both parameters, not belonging to both tables at the
same time.

Is there a way to implement this? Multiple ODAG Script? Thanks

[pedrobergo · Accepted solution]

Hi @aresb 

Probably you´re using the example subroutine from community (ExtendWhere).

Since that you reading diferent source tables (Dim1 and Dim2) you may create two subroutines, filling diferent variables to read the source tables.

So, please take a look on this link that will show to you how to create another one (ExtendWhere2).

https://community.qlik.com/t5/Qlik-Sense-Documents/On-demand-App-Generation-ODAG-in-QlikSense/ta-p/1...

[],

Pedro

[aresb]

Thx, it works!!