UNION (ALL) only gives data from table 1

[mathiasrw]

UNION and UNION ALL only gives data from first table when source are HTML tables while rows from the second table are empty.

Please see the issue in action at: http://jsfiddle.net/yp83t1p9/

The problem is illustrated here where the last "rows" are empty:

[
    {
        "ID": "ID",
        "Name": "Name",
        "Month": "Month",
        "Savings": "Savings"
    },
    {
        "ID": "111",
        "Name": "John",
        "Month": "January",
        "Savings": "$100"
    },
    {
        "ID": "122",
        "Name": "Rianna",
        "Month": "Feb",
        "Savings": "$200"
    },
    {
        "ID": "133",
        "Name": "Michael",
        "Month": "Mar",
        "Savings": "$300"
    },
    {},
    {},
    {},
    {}
]

[micheledallatorre]

Took me ages to understand this was a bug! :(

Same result here, see http://jsfiddle.net/L8471bnk/116/ and
http://stackoverflow.com/questions/35894671/alasql-union-or-union-all-only-gives-results-from-table1

[mathiasrw]

Sorry to hear you spend a lot of time because of this bug.

Thanks for adding material to the case.

[keeganmccallum]

+1

[jamintz]

+1

[fuserMRX]

Hi!

It seems that the issue is still present. The query provided on the stackoverflow by @agershun below does not unite the results and we get only partial result.

https://stackoverflow.com/questions/34527959/parse-a-jsonwith-array-and-objects-and-export-the-data-into-excel-file-in-node/34771859#34771859

Could you please shed the light to the issue?maybe the SEARCH query approach has been changed or something else?

[Co0olCat]

Solved here: #75

[mathiasrw]

Hi @Co0olCat - thank you for tipping in. You are referring to something that got merged in 2015 - are you sure it is still valid?

[Co0olCat]

Yes. thank you.

[jdimmerman]

@mathiasrw what was the solution here? I am still observing this issue as described

[mathiasrw]

Oh!