ALA SQL Query Results

[klautier]

I am trying to combine data from 2 different queries from MS SQL, and so I have tried Query JSON As SQL. The query I want is a left outer join. The query I have written runs, but does not produce a flat dataset, instead it has arrays in arrays, making it unusable as an input for a table. Both data sets only return 1 row for each AccountNumber.

I am using on-prem 3.284.3.

What do I need to do to flatten the data so I can have a standard query output?

[klautier]

I tried to do this as an update, where I add the column names into my left data set, but I still get an error:

[klautier]

I have also tried via a transformer, but get no results, where CrmCount and AccountNumber are on both data sets:

[klautier]

Even if I am explicit in the column names, the data comes out as undefined and in the wrong structure. The source data sets have 6000 and 800 results respectively.