I want to export SO_InvoiceDetail data. In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column. My export currently looks like:
InvoiceNo - Col 1
ItemCode - Col 2
AliasItem - also Col2, with condition that len(AliasItem) <> 0
The export result is 3 columns of data, not 2. Is there a solution for this? Or is there an "if-then-else" type of function that I could use in the conditional calculation to map col2 to the ItemCode if the AliasItem is blank, else use the Alias Item?
Thanks for any assistance.