Combining fields on different DAC in the same GI column

Are you saying the historical data has no relationship to the current Orders?

You should be able to write a conditional formula into the result column definition, you don’t have to pull columns directly:
Here’s an example of someone working with an IF in the result columns.

 

​@darylbowman yes, for now. I think the tables are supposed to link on customer ID and business account ID. But the imported ID for historical orders don’t match the current order’s business ID. The only other field that I see may work would be the inventory ID. 

I'm not sure how you'll get intelligent and useful data unless you can build a solid relationship.

Hi ​@darylbowman we understand that to join the tables we would need accurate relationship, and we have thought about updating the Historical Business Account, so it matches the current ones. With that, we will be able to join the tables on this field. 

However, even with a solid relationship, I’m not seeing how it could work because the order Nbr and Doc Id will still show up in two different columns. It’s like if I want to create a GI that shows both SO and Invoice. We could join on the customer ID, but how can we combine the ordernbr and refnbr into the same column?  Is there a way to combine the two so they show up in one? Kind of like a UNION statement?