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

[qlikviewforum]

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

[anbu1984]

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'));

[tresesco]

Try like:

Temp:

Load

    Concat(AcctID, ',') as TempF;

Tab:

Load * From <>;

Let vString=Peek('TempF');

Trace '$(vString)';

Drop table Temp;

[qlikviewforum]

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

Please help

[qlikviewforum]

Any help on this?

[tresesco]

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.

[qlikviewforum]

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.