Excel sheet data upload question

[Lucky1]

Hello all,

There is an excel sheet to be uploaded the data into a table in service-now.

But that sheet consists of more than one entry to be uploaded into the table.

Here, Business Application is a table, and I want to insert two records into 3 records into it.

1. Cloud ----> there is a field Type and it should select Platform Host

2. App1 ------> here it should select platform application and then Platform Host will become mandatory and there I need to select Cloud.

3. App2 ---> Same like 2nd point.

So, totally 3 entries in this Business application table.

Secondly, there is an Application Service table and there I need to insert 3 records, like as shown in the pic, Dev

Qa,

Prod.

Can someone let me know what transform Script I need to use and what should be the target table and please provide me a script.

Regards,

Lucky

[Ankur Bawiskar]

@Lucky1 

this will be challenging and difficult to handle in excel

what did you start with and where are you stuck?

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

[Lucky1]

Hi Ankur,

Good day!!

Actually to speak not started yet.

If we keep comma separated for Application Services, will it be feasible?

like 

Dev, Qa, Prod

Regards,

Lucky

[Ankur Bawiskar]

@Lucky1 

ideally 1 row with 1 set of information is easier to handle.

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

[Lucky1]

Yeah, that I understood.

But I feel like, we can use split method and then insert the records.

Can you guide me what type of transform script we need to go with?

Is it on Before ?

Regards,

Lucky