Table transformer join with empty tables

Question

I have a use case where I am using multiple table excerpt includes wrapped in a table transformer that joins all results with a key field.

My problem appears when some of the tables are empty (which may happen often in all but two of the table includes).  In this case the sql query reference to the tables 'breaks' because the value that I am looking for is empty.

Is there a way to handle this automatically?

Here is the SQL where sometimes, T3 is actually empty and the transform fails.

SELECT T1.'Agile Team',

T2.'Epics Accepted',

T3.'Epics with Dependencies'

FROM T1 outer JOIN T* ON T1.'Agile Team'=T*.'Agile Team'

Stiltsoft support · Answer

Hi @Maria Del Rosario Gonzalez ,

As @Tomislav Tobijas has kindly mentioned, you may indeed refer to our support portal - here we find all the questions manually and there every ticket is registered. Besides, the support portal is also confidential in case we'll need to investigate smth closely.

For the current case, you may use the following example from our documentation and check if the T3 exists.

The final query may look like this:

IF OBJECT_ID("T3") IS NOT NULL
SELECT T1.'Agile Team',
T2.'Epics Accepted',
T3.'Epics with Dependencies'
FROM T1 outer JOIN T* ON T1.'Agile Team'=T*.'Agile Team'
ELSE
SELECT T1.'Agile Team',
T2.'Epics Accepted'
FROM T1 outer JOIN T2 ON T1.'Agile Team'=T2.'Agile Team'

Tomislav Tobijas · Answer

Hi @Maria Del Rosario Gonzalez ,

I won't be really helpful here but in case this doesn't get resolved in the Community, it might be worth reaching out to Stilsoft support with this question. From my experience, vendors and app developers usually help out by providing some best practices or potential workarounds you can use when it comes to specific apps.

In any case, if you manage to resolve this with the support team, please do share the resolution here for any future reference.

Cheers and good luck,
Tom