Comments
-
Hi @MichelleH Sorry for the late reply, have been off with a bug. For this task i used the formula and this worked a treat and exactly what i needed, thanks for your assistance. Thanks Rob
-
This worked a treat, thanks for your answer.
-
Hi, i have the connector now, don't know why but was not showing up in my search results?! What is the best app store dashboard to use that works with this connector?
-
HI @trafalger, I have worked out that I can use the CSV advanced connector, I can use a http csv or sftp connector within that, in the configuration I can then set it to allow the double quotations and commas within the quotations will not be processed. Thanks Rob
-
Legend, thanks for that, have a great rest of the week.
-
Tip Top, this worked a treat. @RobSomers, have applied the formula in beast mode, is there a way i can reduce to just 2 decimal places, looks like 9.604651162790697:1
-
Thanks @MichelleH, did untick and forced the UTF-8 format our side and looks like it importing now.
-
Hi @MichelleH, yes CSV was selected in the dropdown, i have included some screenshots of the settings of the connector the error message the only think i can think of is that DOMO is not seeing or not like the type of file or its encoding?