Hi,
I have a customer working with TimeXtender 7150.1 connected to Snowflake.
I have a .csv data-source connected through the Ingest. The ingest settings have a number of header rows removed. But in the data received, I have Totaal-rows that I want to skip or filter out.
The option to “filter rows” by right-clicking the data-source in the Ingest area is not available for this source:
My next option would be to add a data selection rule to the table connected to the ingestion.
But that has no effect: my result table has two rows (one from each .csv source) with Totaal.
The above data selection rule seems not to be used.
The only thing I can do to get it working, as far as I am aware, is to manually add a line of code, using the “Custom Code” option:
But I was told / had learned that using the data selection rule, would automatically change the transformation script.
I am not a fan of this solution, as it is not immediately clear to a new user (or to me in a year time) that I have changed the custom code this way.
Can you tell me if there is a cleaner way to have these Totaal rows filtered out?
And not having the option to filter out rows in the ingest now blocked and the not-having-effect of the data selection rule on table level… is that caused by Snowflake, or do I need to setup something differently?
Kind regards,
Rob van den Brink
E-mergo
