Need to ignore spaces in my set variable activity?

Question

I'm new to ADF, I have a column in an excel sheet with spaces in the name I need to set as variable for my parquet file. Changing the column name in the source file is not an option. Is there a way to ignore the spaces so i can run it without an error? My expression builder code in set variable activity: @activity('get_variable_from_excel').output.firstRow.my column name

Thanks in advance

Answer 1

Hi @JH-AM ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

To specify special characters to Azure Data Factory, we can use [''] instead of . to read such elements. Example is as below.

@activity('Lookup1').output.firstRow['test space']  

Please let us know if this helps in resolving the issue. Let us know for further queries and we will be glad to assist.

--

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.