Hi everyone,
I am trying to create a Map/Reduce script to create intercompany bills and post them against the PO when the corresponding intercompany invoice is created.
I have a dataset created that shows each Invoice, Sales Order, Purchase Order, status, etc.
I want to load this dataset in the getInputData stage and create an object for each row. Trying to use query.load and then the asMappedResult() method and keep getting the error SSS_DUPLICATE_ALIAS. I know this is because I have columns with the same id. I tried renaming the columns in the UI on the dataset, but still get the error.
Is it possible to load a query or dataset and rename (assign alias to*) the existing columns somehow, or do I need to build the query from scratch in the getInputData stage?