Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi any thoughts why my variable "vFieldList" i generated empty ? I have builded dynamical fieldlist table for data cleaning.
Hi,
Please check if below helps
ListBoxAuto:
noconcatenate
Load Concat(DISTINCT COLUMN_NAME,',') as FieldList; //Added Concat
load
COLUMN_NAME
resident TMP
Where NOT EXISTS(Col, COLUMN_NAME)
order by COLUMN_NAME asc;
drop table TMP;
LET vFieldList = Peek('FieldList');
DROP FIELDS $(vFieldList) FROM tempSCE; //----> Removed Quotes
Thanks,
Hi,
Please check if below helps
ListBoxAuto:
noconcatenate
Load Concat(DISTINCT COLUMN_NAME,',') as FieldList; //Added Concat
load
COLUMN_NAME
resident TMP
Where NOT EXISTS(Col, COLUMN_NAME)
order by COLUMN_NAME asc;
drop table TMP;
LET vFieldList = Peek('FieldList');
DROP FIELDS $(vFieldList) FROM tempSCE; //----> Removed Quotes
Thanks,