topic How Does Incorta treat NULLs for KEY columns in Administrative Discussions

How Does Incorta treat NULLs for KEY columns

RADSr — Mon, 10 Jul 2023 22:32:45 GMT

I'm in the middle of trying to figure this out - Incorta table w/ multiple key columns, some of which may be NULL on some rows. Do I need to assign ( IfNull ) fake values to these for Incorta to recognize them as part of a key?

e.g. Think Order Header and Lines - if the lines are deleted but the header still exists I want a snapshot of the header w/ no lines.

Re: How Does Incorta treat NULLs for KEY columns

amit_kothari — Tue, 11 Jul 2023 21:29:51 GMT

Yes, please add a NVL or coalesce condition for that key. Also in your example to get header with no lines just enable the 'Show empty groups' in a aggregated insight.

Re: How Does Incorta treat NULLs for KEY columns

RADSr — Thu, 13 Jul 2023 17:22:25 GMT

To clarify - the header/line join is in the source SQL. I hadn't anticipated a use case where a header is created ( which automatically creates a line ) but then the line is deleted.

I think populating the NULLs w/ a value will create a "no rows row" which should be acceptable.

Thank you!