how to Import specific fields only

[Akki1]

Hi,

I have many fields but I there are two fields which are empty and I want them to update with excel.

Start Date

End Date

There is one more field which will identify the Record which to update that is 'GroupID'.

For the respective group id it should go and update the dates there

If there is no mentoined 'group Id'it should ignore creating new record.

Excel will have 3 fields GroupID,Start Date,End Date

[Nayan Dhamane]

Hello @Akki1 ,

Please use the below steps to create the requirement.

1.First create a datasource using the link - Create a File type data source

2.Then attach your file to data source and load the records hence it will create an intermediate table.

3. Create a transform - Create a transform map

4 coalesce a field and load all records - Coalescing

You can also use below link to view step by step process:
https://www.youtube.com/watch?v=X349TlRSkJU

Please mark as correct.
BR,
Nayan

[Saurav11]

Hello,

Create a data source transform map for the table which ahs the fields:- GroupID,Start Date,End Date

Then create the filed map for the three fields in transaform map.

Set the GroupID field map colasce to true this will ensure it  updates record which ahs the same GroupID.

Now in the onbefore transform script add the below line of code:-

if(action=='insert')
{
ignore=true;
}

Please mark my answer as correct based on Impact.