This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 64%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi,
Below is my pipeline and i am not able to select columns by name for "Clean missing data" transformation.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 1%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Hello @Srinivasa Rama Subrahmanyam Jonnalagadda
Thanks for reaching out to us.
The auto-suggestion for column names in Azure Machine Learning only works when the upstream node is a data node and schema exists for the data. This is because the column names are inferred from the schema of the data node.
If the upstream node is not a data node or if the schema is not available, you may need to manually enter the column names or use the column selector to choose the columns you want to use. Additionally, you can use the "Edit Metadata" component to specify the metadata for the columns, such as whether they are categorical or numeric, which can help downstream components to better understand the data.
Please check on your upstream node if you want to use it.
I hope this helps.
Regards,
Yutong
Hi @YutongTie-MSFT thanks for the quick reply. The confusion i have is the upstream node "select columns in dataset" should pass on selected columns down stream at least, if not entire dataset. DO i need to change any settings in "select columns in dataset" to pass selected columns downstream - selectable.
Hi @YutongTie-MSFT thanks for quick reply. Upstream i have "select columns from dataset", and i assume this node (Not sure whether its a data node or not), should pass down selected columns downstream in such a way that they are selectable. Or how do i change settings of "select columns from dataset" to make it happen.
Hello @Srinivasa Rama Subrahmanyam Jonnalagadda
You can have a try, at the meantime, could you please share your input columns format so that we can look into it to see how we can make it happen? Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
@YutongTie-MSFT
I have the same issue.
I am using the Sample Microsoft data; Restaurant Ratings and Restaurant Feature Data.
I am following a basic tutorial, to join the data from the two data sets. For selecting the columns, these were auto-populated.
But for joining the data, I received the same message, and had to manually type in 'placeID'.
I actually ran the model at the Join Data stage, and it was successful.
But now for the Clean Missing Data, I again get the same message "Auto-suggestion for column names....".
Is there some bug in the Designer tool? These are simple .csv files using the drag-and-drop components, so I should not have to manually type column names.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 88%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
To show column names in select columns component, your data should be of type Table format or MLTable format. so upload the files in table format while adding the data