I have the directory structure in S3 as follows: bucket / year / month / day / filenameyyyymmdd.csv with year, month, day and filename change every day. how to get data into a domo dataset. Ex: bucket/2019/05/01/filename20190501.csv bucket/2019/05/02/filename20190502.csv .... bucket/2019/06/01/filename20190601.csv Please…
How to settings to get daily data from S3 automatically according to dynamic structure: [bucket / year / month / day / filenameyyyymmdd] with `year, month, day, filenameyyyymmdd` changes over time.
ETL: How do I count characters in a string(akin to char_length in mysql)? Ex: ABC => Count = 3 ABCDE => Count = 5
ETL: how do I count characters in a string (akin to char_length in mysql)? EX: ABC => Count = 3 ABCD => Count = 4