Greg
- Total activity 11
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 2
Activity overview
Latest activity by Greg-
Greg commented,
Never Mind!I found the field that was set to string in the import job and changed it to Boolean and that fixed the problem
-
Greg created a post,
Export Job Error
Hi there When I try to run an export job to save a table to hive I get the following error: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.BooleanDoes anybody know how I...
-
Greg commented,
Hi Alan I just learned today that we are upgrading to 7.4 in a few weeks.In the mean time your workaround using the formula bar to make the replacement and then referring to that sheet in the SQL i...
-
Greg commented,
Hi Alan It is requesting I run at the bottom but when I do, I get an error.This error log includes the line Unsupported number of arguments: Expected 4 but was 3 Tried on other columns but the issu...
-
Greg commented,
Thanks AlanStill not working for me though... This works as expectedSELECT Entity_LegalName FROM GLEIF ( returns 5K rows) Change it to thisSELECT REPLACE(Entity_LegalName, 'LTD', 'LTD.') FROM GLEIF...
-
Greg commented,
Hi Konsta I am using version 7.2.3I can replicate what you provided in the formula bar, and it works.The sample you provided is exactly what I am after However, what I am trying to do is incorporat...
-
Greg commented,
And also got an error message about the ; it seems it wants ,
-
Greg commented,
Thanks for your quick reply AlanCan't get it working though...I copied your example exactly REPLACEALL(#Sheet!Column; 'A'; 'B') and the first error I got was:Lexical error at line 5, column 12. Enc...
-
Greg created a post,
Replacing Specific Characters
Hi there I am quite new to datameer and I am trying to use an SQL sheet to display data from another sheet and replace characters in a string. I have tried using this syntax: REPLACE (string_expres...