Saurabh Agashe
- Total activity 176
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 53
Posts
Recent activity by Saurabh Agashe-
Adding Blanks in Column Names
I can change the Column Heading back in the workgroup, but I get an error when the Column heading has blanks. If I want a display ready name "Product Name" for example -- how can I do that? The onl...
-
Summing a column
Hi, I have a column A which contains some numbers and I would like to get the sum of these numbers within that specific column A. How do I do that in Datameer? Thanks
-
Cartesian Product - one paired with many
How do I turn a list of items into a paired list with other set values? For example, 12345 54321 into 12345 1 12345 2 12345 3 54321 1 54321 2 54321 3 This is called a Cartesian Product an...
-
Hive connection is missing
Hi I have such small problem: Here is described how to create Hive connection. There is a list of hive connections. But i have only ability to connect to Hive 0.7.*. I cannot select Hive 0.13(it i...
-
changing names of multiple columns
How do i change multiple column names at once -ideally using find and replace as I spend a great deal of time changing col names ?
-
How to convert week part of date correctly?
We are using Datameer 4.5.8. I need to be able to get the start date from a year-week string. There seems to be an issue with converting week parameter to date. The following expressions are not b...
-
Utilizing Amazon Elastic MapReduce as Hadoop CLuster, what's the default region?
Hello, I'm trying to get my jobs executed on an Amazon Elastic MapReduce Cluster. I setup everything including the key pair which is valid in only one region (eu-west). "Failed to connect to job f...
-
How to generate a Version Number based on a Key
Hi I have to generate record version number for a naturalkey(id) based on change_datetime. Below is the sample of input data and expected output. Ive sorted results on ID and changedatetime and i...
-
How to generate a unique row number
We do not have any columns to uniquely identify a record in a workbook and so we have a need to generate a row number(unique) for every record in a workbook. Thanks for the help.
-
How to generate JSON
I am having hard time generating valid JSON from a Excel file with Keys and values. Here is the sample input and expected output. Please send your suggestions. Input: id attributename attri...