Data set import based on common field

[Spade2]

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? 

[AshishKM · Accepted solution]

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

[Ankur Bawiskar]

@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.

[Spade2]

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