question Re: Data set import based on common field in Community Central forum

Data set import based on common field

Spade2 — Thu, 20 Feb 2025 23:37:56 GMT

Hi team

I'm trying to do a data import where the common field between the asset record and the spreadsheet is Assigned user. I need to upload the data to populate the rest of the asset record based on that field. Does this mean I need to tick the Coalesce button and ignore blank fields?

Re: Data set import based on common field

AshishKM — Fri, 21 Feb 2025 00:00:11 GMT

Hi @Spade2,

Configure the unique column ( e..g Asset Tag ) as coslesce = true in transform map.

A user may have more than one asset assigned, but every asset will have unique asset tag. OOTB there is no primary or unique column defined except sys_id.

So you need to consider any column (as unique value ) within the transform map for update on existing asset record.

-Thanks,

AshishKM

Re: Data set import based on common field

Ankur Bawiskar — Fri, 21 Feb 2025 03:17:17 GMT

@Spade2

coalesce on Assigned to is not best as there could be multiple Assigned to users.

For asset table you can use asset tag as coalesce and ensure that's present in your excel file and have field map on it

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Data set import based on common field

Spade2 — Tue, 25 Feb 2025 03:38:50 GMT

Thanks Ankur. Unfortunately, Assigned to is the only common field between my data import and the asset table. The above worked mostly for me but thanks very much for your response. Will be able to use that def for future imports