I have an issue with NetSuite Analytics Warehouse that I have not seen before. I have a few custom datasets I've built from the Cash Sale, Sales Order, and Invoice standard datasets. I want to union these together using a data flow. When I add any one of these datasets into a dataflow, I get nine duplicate lines for each transaction line. This duplication is not happening in the actual dataset; it is only reflected in the data as soon as I add it to a data flow. The first screenshot shows the data preview when I add the dataset into the data flow. There are nine duplicate lines for each line. The second screenshot shows the data preview from the dataset itself. There is no duplication in the dataset.
Has anybody seen this before and knows how to resolve it?