"Load" and "Transform Data" Grayed out/ disabled when using sample dataset.

[Earth]

Only Cancel button is available. Cannot load or transform data.

[Skupreti]

There is a small box on the left side of the excel file in the navigator screen, click inside the box, once you click a green yes sign will appear. Now the load icon is enabled.

Please confirm if you could do it now.

[Syndicate_Admin]

Hello, you must select the data, mark the box next to the name of the sheet, place a green hook and you will be able to use the options.

[pboorugu-yahoo]

You have to select checkbox the worksheet or table within worksheet.

The excel file

dropdown to excel worksheets

Checkbox of the worksheet to be selected.

Load and Transform will turn active upon checkbox selected.

[quinnn]

I am having the same issue and I have selected the sheet by the file, and still no option to load or transform.

Do I need to activate something?

[v-henryk-mstf]

Hi @Earth ,

Whether the advice given by @Anonymous  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[Earth]

Hi Henry, Thank you. However,  "Load" and "Transform Data" are still Grayed out/ disabled when I used an excel file with the sample dataset data. (I downloaded the sample dataset and saved it as an excel file.) Any ideas why? When will the "Load" and "Transform Data"  button be enabled?

[Earth]

Hi! Thank you. However,  "Load" and "Transform Data" are still Grayed out/ disabled when I downloaded the sample dataset and saved it as an excel file. Any ideas why? When will the "Load" and "Transform Data"  button be enabled?

[Perseusvlasov]

You still didn't select the ✔️ checkbox.. click on that squarebox beside the data 

[Anonymous]

HI @Earth 

Once you use any pre-existing dataset. These options are disabled as you cannot edit modify the already published dataset.

[pboorugu-yahoo]

Selecteing Checkbox will solve the issue..

wrong answer please.

[jates111001]

Once a dataset is published, how do you even get back to the screen where you can select that 'checkbox'?  I can seem to find it anywhere.

[Earth]

Hi pranit828, Thank you. However,  "Load" and "Transform Data" are still Grayed out/ disabled when I used an excel file with the sample dataset data. (I downloaded the sample dataset and saved it as an excel file.) Any ideas why? When will the "Load" and "Transform Data"  button be enabled?

[Anonymous]

Hi @Earth , 

You have to select the sheet by clicking on the box near the table name for that table, for the Load and transform data button to be visible. Thanks!!

Cheers 🙂