Merging multiple csv files

[Vipin]

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.

[pqian]

@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.

[Greg_Deckler]

Right, you need to use multiple Merge queries.