Jayraj
- Total activity 8
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 3
Activity overview
Latest activity by Jayraj-
Jayraj commented,
Thank you very much Joel, tried using it and yields the result. But it was crucial to maintain col_f and col_g as string. Appreciate the help, I did it using SUBSTR and removing the leading zeros.
-
Jayraj created a post,
Data type conversion
I am trying to reconstruct a join that was build in some other system using sql to Datameer. Below is the example used to describe the problem: Select x,y,z, from table a left join table b on con...
-
Jayraj created a post,
Creating multiple columns using if else or joins
Hello everyone, I want to perform something like this: select a,b,c,d,e,f,g from table Jay where a=b AND c=d AND e=f I have a, b, c in one sheet and d,e,f,g in other sheet. I am thinking of u...
-
Jayraj commented,
Thank you Alan, it works
-
Jayraj created a post,
Creating a new variable or column using nested 'IF' containing substr, or and then
I want to create a new column using 4 different columns with conditions. I tried using this below formula but doesn't work: IF(SUBSTR(#Sheet1!XXXX;14;1) ='L' OR SUBSTR(#Sheet1!XXXXX;1;1) ='I') TH...