Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'));
Try like:
Temp:
Load
Concat(AcctID, ',') as TempF;
Tab:
Load * From <>;
Let vString=Peek('TempF');
Trace '$(vString)';
Drop table Temp;
It throws invalid expression error. There is one correction in my load statment. I need to use concatenate before the load statement.
Please help
Any help on this?
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.
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.