Reduce Data / Keep possible values removes valid data

[avantime]

Hi,

After reloading my app I reduce the data via macro.

The problem is that the data reduction affects valid data also, more exactly, data in hidden tables (which I trigger using buttons).

Any solution?

[jonathandienst]

Difficult to say without looking in some detail at your data model.

>> more exactly, data in hidden tables (which I trigger using buttons).

I am not sure what you mean by that.

[avantime]

By hidden table I mean tables (or charts) with conditional show rule.

I will try to build an app to show you what I mean.

[jonathandienst · Accepted solution]

The data reduction happens to the data model based on the selections in force when you do the reduction. The status (shown/hidden eg) of front end objects plays no part in the data reduction. The data that is disappearing is being removed from the underlying data model.

It sounds like you are doing this as part of a routine load. There may be a better way to do this in the load script itself.

[avantime]

The data reduction happens to the data model based on the selections in force when you do the reduction.

Didn`t know this, I thought the reduction was done regardless of current selections. This makes sense with the problem I have. Back to the drawing board then. Thanks!

[avantime]

Solved it by adding a Where Exists clause . Thank you Jonathan for your input!