topic Re: Help required in using the Trace statement to know what AcctID's has been loaded. in QlikView

Help required in using the Trace statement to know what AcctID's has been loaded.

qlikviewforum — Tue, 10 Feb 2015 05:00:41 GMT

Hi,

I have load statement something like below I want to know what are all the AcctID has been loaded in the below load statement. How can I use the trace statement so that we know what are all the AcctID's has been loaded with the below load statement. I would requirement comma seperated values of the AcctID.eg: A1234,B4545,C6858...

Concatenate

Load

AcctID,

CustomerName,

Address

From

SourceFile

Where not exists(AcctID,AcctId)

Please help me on this

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

anbu1984 — Tue, 10 Feb 2015 05:10:06 GMT

Temp:

Load

AcctID,

CustomerName,

Address

From

SourceFile

Where not exists(AcctID,AcctId);

AcctIds:

Load Concat(AcctID,',') As AcctIdsLst Resident Temp;

Trace $(=Peek('AcctIdsLst',0,'AcctIds'));

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

tresB — Tue, 10 Feb 2015 05:10:27 GMT

Try like:

Temp:

Load

Concat(AcctID, ',') as TempF;

Tab:

Load * From <>;

Let vString=Peek('TempF');

Trace '$(vString)';

Drop table Temp;

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

qlikviewforum — Tue, 10 Feb 2015 06:18:11 GMT

It throws invalid expression error. There is one correction in my load statment. I need to use concatenate before the load statement.

Please help

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

qlikviewforum — Tue, 10 Feb 2015 06:41:27 GMT

Any help on this?

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

tresB — Tue, 10 Feb 2015 06:45:11 GMT

Unless it is loaded, you can't concatenate it. You can temporarily load the single field as I showed above. Try to post your corrected script.

Re: Help required in using the Trace statement to know what AcctID's has been loaded.

qlikviewforum — Tue, 10 Feb 2015 07:02:25 GMT

Thing is I am using where exists in the load statement. So that is the issue here. if I have already concatenated it I cant load temporily as the where exists will not exists.