Export feature in MDM Data Manager ?

[Former Member]

Hi Experts,

I would like to ask if there is an export feature in MDM Data Manager that would enable me to obtain an excel extract of record details which also include validation result columns ?

Thanks very much for your help

Best regards,

Wei Dona

[Former Member · Accepted solution]

Hi Wei,

The export feature of the data manager, exports just the fields of the repository in an excel.

However for your requirement, there can be a workaround.

Create a status flag and assign it your validation result.

As this status flag is now a part of your repository you can export it.

Hope it helps.

Thanks,

Minaz

[Former Member · Accepted solution]

Hi Minaz,

Thanks very much for your reply.

Could you please give me more in details how to create a status flag and assign it your validation result?

Thanks & regards,

Wei Dona

[Former Member · Accepted solution]

Hi,

You can create a create a Boolean field in the Console for storing the result of the validation.

In the Data Manager go to the Assignments tab and create an assignment.In the expression

editor you can write the validation expression and assign the result of the validation to the field

created above.Now while exporting to Excel from Data Manager you can export this field also.

Thanks and Regards,

Preethi

[Former Member · Accepted solution]

Hi Wei,

Create a field of type boolean say status.

Now create an assignment is Data Manager.

For eg if you want to validate the value of Material type to be XX then

if(Material_Type=XX,True,status).

In the assignment field property select the status field.

Hope it helps.

Thanks,

Minaz

[Former Member · Accepted solution]

Hi Preethi,

Thanks very much for your help.

I think I can manage to make it.

Kind regards,

Wei Dona

[Former Member · Accepted solution]

Minaz,

Thanks very much for your help.

I think that I can manage to make it.

Kind regards,

Wei Dona