-
Scheduled update of an Excel with date in the title possible ?
Hello all, I need to configure a job that has to be updated every day, but the bad thing is that the Excel file source is an extract from a database that is daily generated with the date of the day in the title (then it means a different title then a different file each day). Do you know if it is possible to let Workbench…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
-
Market Share (% of Total) and % Change/Trend Calculations
Is there a way using beast mode, or some other functionality, to create the following two equations in a DOMO card — to display on graphs as well as in a table/pivot table. 1) Market Share as a percent of total. In other platforms like PowerBI with DAX this would be achieved with something like the following random…
-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
Can we upload single excel file with multiple sheet into DOMO and use it?
Hi Dojo, I have many small small data set in excel which is in 12 sheet in single excel file. Can I upload single excel file with 12 sheet of data and use it in domo to create a report or I'll have to create 12 separate data source into DOMO? Thanks Suman
-
Using Sharepoint online connector to extract excel file
I am wondering if anyone has been succesful in pulling an excel file from sharepoint using the online connector. It seems I have tried every variation of the file's server relative URL with no luck. Thanks in advance for any help.
-
Is there a way to add rows to a dataset while in Domo where the dataset was a file upload?
I have a file I want to upload using the file upload connector. I will be turning the dataset over to one of the users and want to allow him to edit the dataset as a webform. He will have to add and delete rows and edit rows as necessary. I want to make it as simple as I can for him. Most of the time he will only have to…
-
Excel from SFTP workbench error
Trying to upload an excel file with multiple sheets using Workbench from an SFTP server, When I validate the settings I get the error: Path extension '.tmp' is not supported. Use ExcelFile.Load method that accepts LoadOptions paramter to explicitly specify source file format. Parameter name: path The path is in the…
-
Issue with the File Upload connector for Excel files.
Has anyone else had issues with the File Upload connector recently? I went in today to update an excel file which only changes monthly. The dataset has been "Preparing" for going on 20 minutes now with no success in sight. In the past, these updates took less than a minute at the most. HELP!
-
Excel Plugin not pulling data consistently
I am running into an issue where identical data pulls are returning different results. Please help!
-
Error while uploading excel sheet through Excel Plugin
Hi, I'm receiving the following error while uploading an excel sheet through the DOMO excel plugin. How do I get rid of this error? Thanks, Angel
-
Workbench v3.xでExcel/CSVを読み込んでもカラム一覧に何も表示されない場合の確認ポイント
Workbench v3.xをご利用中のユーザー様で、取り込み元Excel/CSVファイルを選択したところ、下図1のソースペインのカラム一覧に何も表示されないケースに遭遇する場合があると思います。 [図1] この場合、多くのケースでは以下の3つの可能性のいずれかに当てはまります。 * Excelの場合にヘッダー行の開始位置がA1ではない * Excelの場合にヘッダー行に結合されたセルが存在する * Excel/CSVのいずれの場合にも、ヘッダー行に重複する項目名が存在する 上記いずれの場合も、ファイル読み込み直後にはツール上にメッセージは表示されません。 1の場合には取り込みExcelのフォーマットを確認していただき、[Advanced…