In your Dataiku project, select … > Macros > googlesheets > Import GoogleSheets. This can be done by mean of a scenario step for instance. The macro needs to be run again every time the data content requires to be refreshed. These datasets are copies of the initial Google Sheets. Initially, they will all be added to a zone created after the name of the Google Sheets document. This macro imports all the selected sheets of a Google Sheets document and add them to your project as datasets. following the same rules that are applied when entering text into a cell via the Google Sheets UI.Īdd one dataset per sheet in your project’s flow ¶ Numbers will stay as numbers, but strings may be converted to numbers, dates, etc. RAW: The values the user has entered will not be parsed and will be stored as-is.įormat numbers, dates, or currencies in the spreadsheet: The values will be parsed as if the user typed them into the UI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |