Urgent problem with LOAD and SELECT statement.

[#1]

Hi community

Please in Qlikview, can we use many FROM in a LAOD or SELECT statement?

For example:

LOAD Numcpt as NUMERO,
(CreditSO - DebitSO) as SOLDE
FROM balance.qvd (qvd)
WHERE Numcpt like '10*';

If true, how do reference the differents fields of every table?

Thank you

[vgutkovsky]

No, you can only have 1 FROM per every LOAD. If you need multiple sources and have a SQL DB, then you can reference the multiple tables in a SQL SELECT. For a QVD load, you would need to use either concatenation or joining if you need multiple sources for the same QV table.

Regards,

[Miguel_Angel_Baeyens]

Hello,

What you can do is to load all data you need from all different sources and then either concatenate the results or join them, but only one select by load statement.

Regards