Variable Loop Condition End: Ignore different Table Structure and or Column Types

[mwiegand]

Hi,

I’d like to suggest to ignore different column types / specifications and column count if the option “Collect rows from last iteration only” is enabled.

ERROR Variable Condition Loop End 4:848:0:1003 Execute failed: Input table #0's structure differs from reference (first iteration) table: different column counts 35 vs. 34

I currently have a fallback in place to attempt to mitigate the issue by temporarily saving the results to a table which ensures / enforces column consistency but the Variable Condition Loop End node still “complaints”.

PS: Adding to this. If the error output could be more comprehensive providing information i.e. which columns were not found or which column types do not match, it would be a huge debugging relief too.

Best
Mike

[CarlWitt]

Hello @mwiegand,

the error messages have slightly improved in Analytics Platform 4.6.0:

Execute failed: Input table #0's structure differs from reference (first iteration) table: Column 0 [column2 (Number (integer))] vs. [column1 (Number (integer))]

An option to ignore schema changes when collecting from the last loop iteration only is a very good idea and we have a pending feature request ticket for it.

Cheers,
Carl