Jayraj
- Total activity 8
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 3
Posts
Recent activity by Jayraj-
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...
-
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...
-
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...