vaidyarm
Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
How to Convert Timestamp from 1 min to 5 min
we have the number of rows divided by 1 min each “2023-04-01 12:00:00 UTC” “2023-04-01 12:01:00 UTC” “2023-04-01 12:02:00 UTC” “2023-04-01 12:03:00 UTC” “2023-04-01 12:04:00 UTC” “2023-04-01 12:05:00 UTC” “2023-04-01 12:06:00 UTC” “2023-04-01 12:07:00 UTC” “2023-04-01 12:08:00 UTC” “2023-04-01 12:09:00 UTC” “2023-04-01 12:10:00 UTC” we need to group them over a period of 5 min instead of 1 “2023-04-01 12:05:00 UTC” “2023-04-01 12:10:00 UTC” 0-5 min > 5 min 6-10 min > 10 min Can anyone help me with it? there are a huge number of timestamps, not limited above example, once we have this, we will be able to aggregate data for every 5 minsPivot Data from rows to columns with many possible values for pivot field
Convert this accountId region reporttype count 1 APAC L1 Feedback Report 2 1 APAC L2 Feedback Report 2 2 APAC L1 Feedback Report 6 2 APAC L2 Feedback Report 4 3 APAC L1 Feedback Report 17 3 APAC L2 Feedback Report 4 3 EU L3 Feedback Report 3 to below one accountId Region L1 Feedback Report L2 Feedback Report L3 Feedback Report 1 APAC 2 2 0 2 APAC 6 4 0 3 APAC 17 4 0 3 EU 0 0 3 Note : the report type can have many values so don’t need static way of mapping fields unique key here is accountid and regionRe: Json Parsing issue in json generator
Hey @viktor_n , Actually, the problem is that “$[0].UserIds[0]” is not the value that I am trying to get from the pipeline, but it’s the text itself that is supposed to have $ signed value in it. (its the Mysql query which allows querying JSON data by SQL itself) https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html Text i want to parse : select testfield->>‘$[0].exploreUserIds[0]’ as testfield from sampletable Json through which i am trying to parse : [ { "AccountId": "9999", "FeatureName": "select somefield->>'$[0].UserIds[0]' as testfield from sampletable" } ]3.5KViews0likes0CommentsJson Parsing issue in json generator
I am trying to parse the below JSON in the JSON generator snap but getting the error. Error: Expecting array for JSON-Path array index, found: Map Payload : [ { “AccountId”: “9999”, “FeatureName”: "test json -->>"$[0].UserIds[0]" test end " } ] It’s simple but still not getting through…3.9KViews0likes4Comments
Groups
Higher Ed Users Group
This user group is for customers within higher education.0 Posts
