We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

CSV file Transform script

Meenal Gharat
Tera Guru

‎12-08-2023 05:20 AM

Hi Expert,

 

I'm trying to Map data from CSV file which is using " | " pipe as a delimiter.

Is this possible to import the CSV file and than transform to the Target table fields.

As I tried mapping the fields. this how it is seeing.

 

MeenalGharat_0-1702041523730.png

 

 

kindly assist!

 

 

Best Regards,

Meenal Gharat

 

0 Helpfuls
  • 495 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron

‎12-08-2023 06:03 AM

Hi @Meenal Gharat 

 

You can try with Auto mapping 

 

LearnNGrowAtul_0-1702044191715.png

 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls