Working in a workbook with the new Anaconda toolbox. Trying to get data from another workbook as a dataset in this workbook with this tool but having trouble. Not sure how to upload the data to the Anaconda cloud, can you show me how?
Suppose you have two workbooks – A.xlsx which contains the dataset and B.xlsx which you want to have a copy of the dataset.
In workbook A,
- Open Anaconda Toolbox, sign in
- Go to Data Connections
- Create a New Project
- We’ll give it the name “Test data”
- Ignore Invite from Organizations for now
- Click Save
- Create a New Dataset
- Click to select some Data to Connect – this is where you choose the dataset to upload (either an entire sheet or a Table or a custom range selection)
- Choose the “Test data” project that we just created
- Give the dataset a title – we’ll call it “My first dataset”
- Click Connect to Cloud
In Workbook B,
- Open Anaconda Toolbox, sign in
- Go to Data Connections
- Expand My Datasets – you should see “Test data” project
- Expand “Test data” project – you should see “My first dataset” listed
- Click the cloud icon with a down arrow
- Choose where you want the dataset to be added – overwrite a sheet or an existing table
- Hint: If you want it to be a new sheet, manually create the new sheet, then click to select and choose the new sheet
- Click Connect to Workbook
- The dataset should appear
More information can be found in the docs.
ty for this …it worked but the data from the uploaded table is not being rendered onto my sheet as you can see from the attached picture…pls advise
That is strange. I haven’t seen it write the headers, but none of the row data.
Have you tried it with a different dataset?