is it possible to add table names in expression

[vikey]

Hi,

Is there  any way to add table names in expression, if we load the data from different connection from sql.

Ex:

LIB CONNECT TO 'd- a1';

LOAD

a,

b

from xxx;

LIB CONNECT TO ' d-a2';

LOAD

A,

from yyyy;

LIB CONNECT TO 'e- a1';

LOAD

a,

b

from zzzz;

LIB CONNECT TO 'e- a2';

LOAD

a,

b

from vvvv;

Note: where  d, e are environments like (dev, prod) and a1,a2 are clusters names in it.

1.how can we create chart for environment separately. Based on the selected environment ,data as has to changed.

2. based on the environment selection in one chart and  we need to select the clusters data separately in other chart, is it possible to do it?

[Akeem]

In this case the idea is to have lots of identical tables. But they would contain different data. The name of the table would be for instance TAB_2018_06_27, TAB_2018_06_28 so I could use date expression to get a proper table. But I have no idea how to specify that I need all logins from TAB_2018_06_27 not from any other tables which contains same column named 'login'.

OptOnline