Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Removing duplicate rows, data from different (joined) data sources

I have a report that's a combination SalesOrderHeaders and SalesOrderLines:   Customer, Service Purchased, Invoice Date, Amount Due   Boston College, Subscription for HE, 4/5/2020, $400 York Cit...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    ...or I have to build a named TABLE out of at least three database joins, filter it down and then jump over to the report view to finish the summary. Parking it for tonight - shouldn't be doing work today anyway 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry for the serial newbie questions, but where can I find the name of the Table that's currently in my report view? I'm getting an error because I don't know what to substitute for "Table" in the examples. Or does this only work in the source data files? (the things I filter on have values across two joined data sources).

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Anonymous  the table name in the formula will likely be SalesOrderHeaders or SalesOrderLines, depending on where the columns are located. You can find the name of the tables in the fields pane - all the fields (aka columns) are grouped by Table name.