Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to find out the number of columns present in an excel sheet in the script?
Thanks,
Asma
Hi,
In the script after you've loaded the excel file then use NoOfFields() function'
So in script below, vFieldNo in UI will give you the number of columns in excel.
MyTable:
LOAD
*
from ExcelSource
;
LET vFieldNo = NoOfFields('MyTable');
Hi,
You can use :
RecNo() as RawNo.
Thanks,
AS
NoOfFields('table_name')
will return the number of column last loaded in the table