How to download panel data from Refinitiv workspace in a long format but not wide format?

qwwang

I would like to extract ESG score of all public and private firms for the past 20 years. However, the data I extract from the screener is wide format, which is inconvenient to use. How can I download it in a long format? At the same time, the fiscal year end item does not have time series option as the ESG score item. Could you please advise on these questions? Thank you very much.

Jirapongse

@qwwang

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. If the question is about the Screener app, please contact the helpdesk support team directly via LSEG Support.

However, you can use the LSEG Data Library for Python with the Screener, as mentioned in this Find Your Right Companies with SCREENER | the Data Library (Python) article.