N

262 Messages

Sunday, August 15th, 2021 12:04 PM

Update parent attribute values or vice-versa

Hi all,

Let us say, I have a column asset which has an attribute “PII” set to YES. I would like to mark then the “PII” attribute of the table asset to YES. That is, if at least one of the columns has “PII” attribute set to YES, then the “PII” attribute of the table (i.e. the parent) must also be updated to YES.

I plan to create a workflow to do this. Reading only the metadata since last update could be a challenge.

Or, do you think having an Excel macro based import could be a much more simpler solution?

Or, I am also thinking if guided Stewardship could do any magic here automatically, though yet to check.

Br,
Noor.

40 Messages

3 years ago

PII inheritance.txt (6.6 KB)

Please find the workflow I use for this attached. I usually trigger it based on new relation or update of a relation.

I hope this helps.

262 Messages

Thank you Stijn. Will use this as the baseline.

262 Messages

Hello Stijn, all -

a change in my requirement : is it possible to only DISPLAY the calculated attribute value instead of marking & storing it through a workflow? That is, display PII=YES for a table when any of its columns are marked as PII=YES.

Hi Noor,

We currently have no feature around ‘derived attributes’ that can be calculated on the fly.

I think indeed that for now the best way would be to use a workflow. Be careful with event triggered workflows though (on attribute changed, on relation added,…) in terms of performance. These workflows could have an impact on ingestion or Excel import speed.

262 Messages

Thank you very much Roeland for the information.

Loading...