Is it possible to import data based on filter condition?

[Former Member]

HI All,

Is it posisble to import data based on fillter condition? Suppose I have following data

Name,City

A,HYD

B,HYD

C,MUM

D,DEL,

E,DEL

F,HYD

Now I want to import only records where city is HYD, is it possible through import manager?

Thanks

Rajeev

[Former Member]

Hi Rajeev,

In addition to Maheshwari, I would also like to add you can use a very simple approach for such requirement. All you need to create a validation where city equal to HYD and set this validation property Automatic Execution on error in Data Manager. So whenever a record gets created either through import Manager or directly into data manager, records voilating this validation will result in fail thus only records city = HYD gets created into MDM.

Kindly revert with result.

Regards,

Mandeep Saini

[former_member207367]

Hi Rajeev,

You can achieve that using MDM workflows by using a validation and a Roll Back in the stop step.

Start (Check Out) - > Branch (a Validtion which checks the city is equal to Hyd) on Yes -> Stop (Check in )

on No -> Stop (Roll Back)

Please let me know if you need any other information

regards

Sowseel

[Former Member]

Thanks,

So we cannot achive this using normal import manager with out using Wworkflow.

Thanks

Rajeev

[former_member207367]

Hi Rajeev,

I think YES we can not control in normal import manager.

regards

Sowsel

[Former Member]

Hi Rajeev,

You can filter records during import if one of the Matching field is of type Lookup.

In your case if you create City as flat lookup table in MDM & maintain lookup values in DM(Just as an example), then you can import only records where city is HYD.

Map Name & City, Then in Match Records tab select both the fields (Combination)

then right click on it & select Filter.. option.

Now new pop up will open where you be able to see ur Lookup table values, from there select HYD and Add

Now in default Import Action, set Create Action for None/None (All other will be skip)

This way you will import only HYD records.

But this is possible only on Lookup fields & not foe Text fields

Hope this will help you

Thanks & Regards,

Mahi