a!queryColumn for columns that are data types

Question

How do I choose specific columns, order columns, and alias columns that are not primitive types?

Peter Lewis · Answer

You can use dot notation in both the field and alias to select specfic fields and define the output. For example, if you want to the fields "reworkNew" and "reworkOld" from the nested cdt, you can provide the dot notation directly in the columns like this with a top level alias used: 
 ...
a!queryColumn(
 field: "reworkRoutes.reworkNew",
 alias: "reworkNew"
),
a!queryColumn(
 field: "reworkRoutes.reworkOld",
 alias: "reworkOld"
) 
 If you do this, you will see "reworkNew" and "reworkOld" as fields at the top level of the dictionary.

a!queryColumn for columns that are data types

Top Replies