Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have around 50 csv files with Timestamp and value like:
Timestamp Value
Fri 01 Apr 2016 02:10:00 GMT 10
Fri 01 Apr 2016 02:15:00 GMT 20
Fri 01 Apr 2016 02:20:00 GMT 30
And another file
Timestamp Value
Fri 01 Apr 2016 02:10:00 GMT 8
Fri 01 Apr 2016 02:20:00 GMT 5
Fri 01 Apr 2016 02:25:00 GMT 6
In the above cases some time stamp are missing. I have them in the following format
Timestamp Value Value
Fri 01 Apr 2016 02:10:00 GMT 10 8
Fri 01 Apr 2016 02:15:00 GMT 20 -
Fri 01 Apr 2016 02:20:00 GMT 30 5
Fri 01 Apr 2016 02:25:00 GMT - 6
Thanks in advance.
@Vipin What is the desired result?
"Merge" queries is like a join, you are using timestamp as a key and joining them across a set of queries. If this is what you are after, then what you did is correct (and the output is correct too). Aside from the fact that timestamp isn't the best key to join with...
If you want to CONCATENTATE the csv files into one set of results with the same shape, then APPEND queries is what you should be using.
If you can define your scenario a little better, we can help you with ways to write the query in a more efficient manner.
Right, you need to use multiple Merge queries.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |