Azure ML Designer not auto-suggestion column names

Brian Van Steen 20

I am working with the Titanic dataset (imported as Excel .csv into Data as Tabular, and supported by Auto ML), and cleaning missing data.
For the first Component (first image), I could select the column automatically by Column Name (Cabin). I submitted that job, and it ran successfully.
For adding the second Component, after the first job completed, auto-suggestion is not working (second image).
I have noticed this problem, and so specifically set up two Components to highlight the issue.
Why is auto-suggestion not working?
Thanks.
Screenshot 2024-05-15 081941

Screenshot 2024-05-15 082034

santoshkc 5,165 Reputation points Microsoft Vendor

2024-05-15T14:06:51.1933333+00:00

Hi @Brian Van Steen,

Thank you for reaching out to us with your query.

Based on your input, it seems that you are using two Clean Missing Data components to clean the missing data, and the Auto-suggestion feature is not working in the second component.

In this case, it's important to note that the Auto-suggestion feature in the Clean Missing Data component only works for the first component. If you are using multiple Clean Missing Data components, the Auto-suggestion feature will not work for the subsequent components.

To resolve this issue, you can manually type the column names in the second Clean Missing Data component. Alternatively, you can use the first Clean Missing Data component to select the further columns automatically by using Auto-suggestion.

For more info see this documentation: Tutorial: Designer.

I hope this helps! Thank you.
Brian Van Steen 20 Reputation points

2024-05-15T16:55:34.9233333+00:00

OK, thank you @santoshkc .
I understand about having the multiple "Clean Missing Data" components.
But this also occurred in the following scenario, where the columns were auto-suggested for the "Join Data" component, but then auto-suggestion did not work for the "Clean Missing Data" component.
Obviously, manually typing is an option, but this is prone to typing errors. Additionally, if many columns need to be identified, manually typing will be very tedious.
santoshkc 5,165 Reputation points Microsoft Vendor

2024-05-16T09:12:52.9933333+00:00

Hi @Brian Van Steen,

Thank you for the follow-up query. I understand you concern, but you need to manually type the column names or use the first "Clean Missing Data" component to select the columns automatically by using auto-suggestion. If you are experiencing issues with the Auto-suggestion feature, you can try checking the column names, refreshing the page, or using the "Select Columns in Dataset" option to manually select the columns.

I recommend you to raise a support request with Microsoft Azure support for further assistance.

I hope you understand! Thank you.

Share via

Azure ML Designer not auto-suggestion column names