How to SFTP file in DoMo
Hi All, I need to sftp file on other server. Could anyone help me with the steps/connector that can be used to achieve this? -Guest1298
How to find position of string in Simple Domo ETL ( NOT in Beast Mode)
Hi All, I have requirement where i need to find a position of character in Domo ETL (Not Beast Mode). Can anybody assist me on this? Below is the example String ----> Asx@par Ans = 4 The symbol @ can come anywhere in input string so i need to find it's position. Thanks in Advance.
DoMo trims leading zero while loading Text data into domo
Hi All, I am using simple DoMo ETL (Not Beast mode) and I have an issue with DoMo. I am loading text data from salesforce into domo using "salesforce" connector. The text data contains all numbers with leading zeros. Since there are no chanracters present in text data Domo treats it as number and trims leading zeros while…
Data Extraction from Teradata
Hi All, I need to create a DoMo Dataset by extracting a data from Teradata. Can anybody help me know which connector needs to be used and steps to fetch data from Teradata? All your help is appreciated.!!
How to find first non-zero number in TEXT data type in DoMo ETL (Not Beast Mode)
Hi, I have a business requirement where i need to find first non-zero number in a TEXT column which has leading zeros. The position of non-zero number is not fixed in text column. Can Anyone help me to find logic for the same in Domo ETL? Below is the example where i need to find whether the text begins with number 2 by…
Pulling CSV file from UNIX Server
Hi All, I am trying to pull CSV file from UNIX server using below DoMo connectors but getting some errors. 1) CSV SFTP Pull Connector - Inspite of providing correct credentials and hostname with appropriate syntax I am getting error as "Failed to Authenticate. Verify the credentials and try again" 2) CSV Advanced Connector…
Export filtered data into CSV/Excel
Hello Experts, For one of our business partner we have created a dataset as per his business requirement containing @500,000 records. He applies filters on "Data Tab" of that dataset to view data as per his requirement. Once filter is applied, record count reduces to @1000 only and he need to export these 1000 records into…
Passing Value At Run Time
Hi All, Is there any way that can be used to pass the value to DoMo Dataflow at runtime? Thanks & Regards usr12321
Find/Search a file in DoMo Dataflows
HI All, I have hundreds of dataflows developed in DoMo ETL where i need to find all dataflows where file 'xyz' is used as input. Is there any option available in DoMo to find/search required file?