Jee
- Total activity 59
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 19
Comments
Recent activity by Jee-
Hi Alan, Thanks for your reply. But, I am getting syntax error for the below formula, CASE("d";#Sheet1!number;1;"a";2;"b";3;"c") Here, If number = 1 - it should return "a" , if number = 2 - return ...
-
Thanks Joel, I got it..
-
Hi Alan, Thanks for the reply. But, I have been asked to add UUID for each record to identify uniquely. And, one more thing, I need to add some extra columns like warehouse-id, audit_id. I know h...
-
Just a random string, but it should be unique.
-
Hi Konsta, Thanks for the reply. Is it same as generating unique UUID string for each record. Becaue, I need to generate unique UUID String for each record.
-
Hi, These are 9 column's in the Target table, 1. IDP_WAREHOUSE_ID2. IDP_AUDIT_ID3. IDP_DATA_DATE4. DM_OBJ_VERSION5. DM_WORKBOOK_NAME6. ACTIVITY_TYPE7. ACTIVITY_PURPOSE8. DESCRIPTION9. ACTIVITY_ID ...
-
Hi Konsta , Thanks for your reply. How to generate uuid(ofworkbook) ? For example, I have columns name and age. Now I want to add an another column UUID. I know the value is going to be same for al...
-
Hi Alan, Thanks for your support. I followed your steps. I tested on both Datameer versions ( 6.1.10.3and 6.1.20.1). I didn't find any changes between the filters as you said. Results from Versio...
-
Thanks for your support..
-
Thanks Alan. Moreover, My source data in workbook(after converting String to date using ASDATE) is as below: Feb 10, 1975 12:00:00 AM Oct 7, 1970 12:00:00 AM Jan 5, 1985 12:00:00 AM In the FlipShee...