Fieldname Function

[Anonymous]

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

[zebhashmi]

you can pass the result to some field like

ID & FieldName(1,'Table1') as ID2,

[Anonymous]

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.

[Anonymous]

I can add this anywhere in the script coz it throwing error is I add this as it is.

[zebhashmi]

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

[zebhashmi]

your table has to be in memory.

[Anonymous]

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;

[zebhashmi]

New:

Load

FieldName(2,'test')as ID1

FROM [lib://AttachedFiles/Temp.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

But I do not have this excel sheet.

FROM [lib://AttachedFiles/Temp.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

I did

New:

Load

Fieldname(2,'Location') as ID1

Resident Locationlevels;