Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table location and I want to find the fieldname as well as field number from the table. How can I do it?
I know the syntax of Fieldname function but don't know how to and where to place this syntax in the script to make it work.
FieldName(1,'Table1')
Thanks in advance
you can pass the result to some field like
ID & FieldName(1,'Table1') as ID2,
I tried let a= NoOfFields(location) in script.
But when still I am not able to see how many fields are there in this table.
I can add this anywhere in the script coz it throwing error is I add this as it is.
test:
LOAD
ID,
MapSq as MapSq.map
FROM [lib://AttachedFiles/Temp.xlsx]
(ooxml, embedded labels, table is Sheet1);
Tag field MapSq.map with $geomultipolygon;
New:
Load
ID & FieldName(2,'test')as ID1
FROM [lib://AttachedFiles/Temp.xlsx]
(ooxml, embedded labels, table is Sheet1);
your table has to be in memory.
So my table name 'Location ' is already used in the script. In this scenario how should I add it in the script.
select * from Location;
New:
Load
FieldName(2,'test')as ID1
FROM [lib://AttachedFiles/Temp.xlsx]
(ooxml, embedded labels, table is Sheet1);
But I do not have this excel sheet.
FROM [lib://AttachedFiles/Temp.xlsx]
(ooxml, embedded labels, table is Sheet1);
I did
New:
Load
Fieldname(2,'Location') as ID1
Resident Locationlevels;