Sort the substrings of Timestamp column in azure data factory
enter image description hereMy question is , I have a file in .txt format where there is a column called Timestamp along with many other columns.
Timestamp 01.06.2021 10:30:45...row 1 01.06.2021 10:40:45...row 2 01.06.2021 10:31:30...row 3
Now I would like to sort them in correct order, the required o/p would be:
Timestamp 01.06.2021 10:30:45....row 1 01.06.2021 10:31:30....row 2 01.06.2021 10:40:45....row 3
But the problem is I applied a data flow in ADF, with the sort activity but the files are not changing. Any help would be highly appreciated.
The error is caused by the string 01.06.2021 10:30:45 is not a valied date string, that's why the sort doesn't work.
Please convert it to correct date data type with Derived Column and then sort again. For example:
Source:
Derived Column: expression toString(replace({Timestamp }, '.', '-'),'dd-mm-yyyy hh:mm:ss:sss'):
Sort active:
- linux shell, sort column 1 in ascending order column 3 in descending order
- Sort List in reverse in order
- Sorting an array based on time stamp value from JSON Response
- How to sort collection in my pre-defined order?
- Why is there no SortedList in Java?
- Sorting with AlgoBuild. Why do I get an index is out of range error?
- Lexicographically sort file by line, reading right-to-left
- How to sort string array in descending order in Bash?
- Method to find second highest number in an array in java
- How to sort a list of lists of lists by the total number of items?
- Sort array of objects by one property
- Omiting Items During Sort in Vuetify Datatable
- How to sort an array created by the directory_helper in CodeIgniter
- Max Heap finding kth smallest elements
- How can I sort two vectors in the same way, with criteria that uses only one of the vectors?
- How to sort an array of integers?
- Sorting a ctypes list without grabbing the value
- How do I sort a generic list using a custom comparer?
- What is lexicographical order?
- Quicksort with Python
- sorting in mongodb aggregation according to timestamp
- how sort in reverse order xts object
- Laravel : sorting filter brands doesn't works but error points to an other function (which works)
- Adjacent items in Quicksort's output: Does the algorithm guarantee they have been directly compared?
- Laravel my sorting filter doesn't work but i have no error or no messages
- Simple function to sort an array of objects
- Arranging bars in ggplot
- How to sort with incomplete ordering?
- SSRS - Sort table based on column value
- c++ swapping content of array - Selection Sort