Hi
I want to DISTINCT duplicate data like the attached image.I know that using recordtype of grouping it can be distinct data.As my requirement i want to distinct value columns and other columns.
How can I implement it?
Discussion posts and replies are publicly visible
My question is what makes these rows unique? is it the Country or the code? Do you have data where a country has two codes and you would need those in two different rows?
Konduru Chaitanya
I want to know how to select DISTINCT in appian , so I created some test data plz don't mind about the data.
a!queryAggregation(aggregationColumns: {a!queryAggregationColumn(field: "distinctColumn",isGrouping: true),