Hi, I am trying to connect cloudsql MYSQL database with alteryx. I was able to connect to DB if it has public IP, but want to know about the ways how this can be done if th e DB has only private IP. One way I thought is using authenticate proxy in local system and use it. Not sure if this thought is correct. Please suggest me some ways how this we connect connect to cloudsql MYSQL instance if it has private IP. Thanks in advance !
... View more
Hello, I am currently facing a challenge and hope someone can assist me. I have a table that logs the activity of wells, including their phase, the footage drilled each day, and the daily costs. We aim to evaluate how costs change over the distance drilled per well, categorized into buckets of 1,000 miles (e.g., 0-1,000, 1,000-2,000, etc.). The total footage drilled per well varies, with some wells having drilled 10,000 miles or more, while others have less. We are certain that average costs differ across these footage buckets, but we need to determine the extent of these differences. Attached is a sample of fictional data and the workflow I have started. Any help would be greatly appreciated!
... View more
Hello, Can somebody knows how to resolve this problem? I got an excel file which got sheet 1 and sheet 2. I want to merge sheet 1 and sheet 2 into one csv file. As you can see values are stored in one cell. Is it possible to split those value into separate cell like below? Final view Best Regards, Sebastian
... View more
Hi, I have a folder with various files and they all have 2-3 sheets each. How can I open all the files and get all the sheets? I need to convert the .xls format files to .xlsx format essentially.
... View more
hi community, I like to dynamically clean-up and avoid the data-cleanse tool. I created below Multi-Field Formula and it gives an error when the first field is a numeric type. Any way to 1) fix this error and/or 2) enhance the steps/formula? Thanks a lot :D Formula used (applied to 'All Types' and all fields, incl. unknown): IF isnumber([_CurrentField_]) and isempty([_CurrentField_]) THEN tonumber([_CurrentField_],0,0) ELSEIF isempty([_CurrentField_]) THEN Null() ELSEIF IsString([_CurrentField_]) THEN trim([_CurrentField_]) ELSE [_CurrentField_] ENDIF
... View more