Create OLA using transform map

[Debasis Pati]

Hello Team,

I have an excel sheet of group record data.I want to create one one individual ola record for each group .
My group data is as follows

Name	Type	Line / Vendor Manager	Description	Group email	Vendors
FIT	incident, request, problem, change	Acer	FIT support group	fitdesk@test.com
IT SERVICE DESK	incident, request, problem, change	Adobe Systems	IT SERVICE DESK group	itservice-desk@test.com

the below is my ola conditions how it should be created

Title

Name

Duration Type

Duration

Schedule source

Schedule

Timezone Source

Target

Type

Table

Start

Pause

When to Resume

Stop

When to Cancel

Retroactive Start

Set Start to

Retroactive Pause

SLA Breakdown Config (Assignment Group and Assign to)

Resolution OLA

Team1-Fulfillment

User specified duration

Breached on 'Due Date'

SLA definition

8-6 weekdays

The caller's time zone

Resolution

OLA

sc_task

Active = true

State = Closed Complete

State = Closed Incomplete OR Closed Skipped

Yes

Created

N/A

TRUE

AND Assignment group  = Team1

AND Assignment group.Vendor is Empty

Now instead of Team1 it should replace the group name for example "FIT" is my group's name.
also in condition also it should build active true assignment group is fit like that.

I want to use transform map and create bulk ola records.
what approach i should do to get his done.

@Ankur Bawiskar any suggestions?

[Ankur Bawiskar]

@Debasis Pati 

User Specified Duration has particular Duration which needs to be set

when you give Duration Type = Breach on Due Date then Relative Duration works on - Task record comes up

The combination you are looking is not allowed on form

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Debasis Pati]

Yes i too found that.
@Ankur Bawiskar 

if i select Duration type as breach on Due date it will automatically take the due date of the table"sc_task" due date field right no need to explicitly mention that field any where on any field?

[Ankur Bawiskar · Accepted solution]

@Debasis Pati 

correct it will pick the due_date field present on Task table

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏