Re setting LET value - Qlik Community

johngouws · ‎2014-05-27

Hi,

I have sets of similar data from various clients. From these I want to create initial QVD's.

I use LET to create a date variable to load the data up to.

The principle works perfectly when I connect and load from 1 data source from say tab "Client1".

However, when I try to load data from tab "Client1" and "Client2", the script fails.

When I load tab "Client2" on its own, it runs perfectly.

I have tried clearing LET with LET = before moving from Tab1 to Tab2, without success.

Any thoughts would be appreciated.

Thanks - John

Anonymous · ‎2014-05-27

Hi,

Similar data in the sense, do u have all the field names from both clients similar? try using qualify.

HTH,
Ravi N.

rwunderlich · ‎2014-05-27

Can you post your script as well as the specific error message?

-Rob

CELAMBARASAN · ‎2014-05-27

I hope somewhere you missed you out the semicolon at the end of the statement.

I guess it will be at the last statement of the Client1 tab.

To tell further you could post your script and error message.