Table Tool Missing Column

[Cagahan]

I have table coming from cross tab tool to table tool. The columns are dynamic. Sometimes, a column may not present but the next day, it may present. 

However, in table tool, when a column is missing, it gives error and does not give the output. Is there a way to teach table tool to "only if the column is there, apply the format rules, if the column is missing, no action required." 

Otherwise, maybe another solution would be to fix the column names and then, add the values there. So that if column is not present, no values there, just give 0, etc. 

Any help would be appreciated. 

[Krzysiek]

Hey!

Have you tried selecting 'Dynamic or Unknown Fields' option in your table tool?

[Cagahan]

Yes, unfortunately it changes nothing. The tool says the column is missing, but it is missing for today. Tomorrow, it may be there since the data is daily/dynamic. 

[Krzysiek]

'Missing' is just a warning and shouldn't stop the tool from generating the table, it would be with one less column than usual.

Do you mean you cannot see an outcome in table tool when the field is missing? or maybe you goal is to see the missing column in the table anyway, yet with empty records?

[Krzysiek]

I've just spotted, that you use grouping and this is why you get the error. 

So checking them out should do the work.

 - marked in green this time

[Krzysiek]

If you don't want to deselect Missing Grouping Fields manually each time the change occurs, you may want to apply some changes in your workflow to get that updated  automatically for you based on Field list.

To achieve that, you may want to add:

1) List Box Tool - and select option "All checked by default" & connect same data that is coming to your Table tool to the ListBox Incoming top Q anchor (as is in Screenshot)

2) configure Action Tool to update GroupingFields & connect Action Tool with your Table tool (as is in Screenshot)

[CharlieS · Accepted solution]

It seems like the issue isn't just dynamic fields in the table tool, but you've applied formatting rules to fields that may not always be there, causing the rule will error. 

It is possible to dynamically create/edit/remove formatting rules by editing the inner XML of the table tool using a batch macro. I'll attach an example where I dynamically create formatting rules to highlight field changes so you can see how these mechanisms might work. 

[Cagahan]

Thank you Krzysiek and Charlie! 

as Charlie said after I applied list box tool solution, it solved half my problem but had trouble with formatting.

Now i will apply dynamic table style rules macro on top of it! Thank you both 🙂