How to get the field name returned from get_data query in Python

Hi,

I am wondering if it is possible to return the requested field name from a get_data query in Python? In the Excel TR function I would use CH:fieldname, but adding 'Ch':'fieldname' to the get_data parameters in Python doesn't seem to work.

Any help much appreciated.

Thanks,

Nick

Best Answer

  • m.bunkowski
    Answer ✓

    Hi @nickzane

    You can add .fielddisplayname to the field parameter to get that info. You can also use .fielddescription for a more descriptive information.

    Please see the example below:

    ek.get_data('TRI.TO', ['TR.REVENUE','TR.REVENUE.fielddisplayname','TR.REVENUE.fielddescription'])

    If you want to see what other suffixes can be added you check that using an Excel build formula tool.

    image

Answers