Data not read!

[#1]

Dear All,

I source data through 2 ODBCs from aprox. 100 SQL databases in each and 10 tables in each SQL db using loops within every single ODBCs i.e.

ODBC1

Data:

SQL TABLE 1 "for next " loop DB1 to DB100

SQL TABLE 2 "for next " loop DB1 to DB100

...

SQL TABLE 10 "for next " loop DB1 to DB100

ODBC2

CONCATENATE (Data)

SQL TABLE 1 "for next " loop DB1 to DB100

SQL TABLE 2 "for next " loop DB1 to DB100

...

SQL TABLE 10 "for next " loop DB1 to DB100

When trying to reload data only ODBC1 is read ODBC2 is omitted. When I change the order to ODBC2 ODBC 1 again only first one - ODBC2 - is read.

Is it a bug or am I doing something wrong?

BR,

Przemek

[Anonymous]

Hi Przemek,

Maybe you've resolved your question by now, but anyway...
When I said that there could be many solutions, I didn't promise that there could be always a simple solution. Often you have to use more or less complex approach.
I cannot give you a specific adivice because it requires understanding of the specifics of your situation. Forum is not the best place for an involbved consulting process.
I can tell though that there is at least one essential error here. Notice that you are trying to get the number of rows from the table that has been dropped:
LET LiczbaKlientow = NoOfRows('DZ_Klienci_temp');
Apparently all actions after this do not produce any result.

[#3]

Hello Michael,

Unfortunatelly, cutting off the drop part didn't help. I'll educate myself a bit more and be back to the topic in the future. Thank you.

BR,
Przemek

[Anonymous]

I suspect that what you're trying to do is rather simple, but I can't help without good understanding the structure of the data (multiple databases, tables of identical structure). My guess is this structure was created to make the reporting easier. Never a good idea for QlikView. If you have authority for this - do not use this structure and load QV app from the raw data.