ContributionsMost RecentMost LikesSolutionsRe: Delaying a process I sincerely appreciate your excellent explanation j_angelevski ,Your contribution has been truly valuable. Thank you very much! Re: Join and In-Memory Lookup not working Hi WhatIsThis Left and Right Path should be same, it means it will take common column from both table and join those tables on basis of that. Hope This might help you!! Re: Delaying a process Thanks j_angelevski Its working now,Please tell me how to learn more about various snaps like you know,I want to be more confident in snaps in snaplogic Delaying a process How can i delay a process according to our needs, is there any snap to perform wait operation? I tried with script snap, mentioned there to delay for 15 seconds,but its taking more time than 15 seconds. CODE # Import the interface required by the Script snap. from com.snaplogic.scripting.language import ScriptHook from random import randint from time import sleep import time class TransformScript(ScriptHook): def __init__(self, input, output, error, log): self.input = input self.output = output self.error = error self.log = log # The "execute()" method is called once when the pipeline is started # and allowed to process its inputs or just send data to its outputs. def execute(self😞 self.log.info("Executing Transform script") while self.input.hasNext(): data = self.input.next() time.sleep(15) map = {"out": data} self.output.write(map) self.log.info("Script executed") # The "cleanup()" method is called after the snap has exited the execute() method def cleanup(self😞 self.log.info("Cleaning up") # The Script Snap will look for a ScriptHook object in the "hook" # variable. The snap will then call the hook's "execute" method. hook = TransformScript(input, output, error, log) This code should perform 15 seconds of wait operation,but taking long time. SolvedRe: Email Snap batch or delay between sending each message Hi darshthakkar I tried the code,but its taking more than 20 seconds. Re: How to delete extra columns in csv file which have no data in it Hi koryknick , Thanks For suggestion, but its working partially. Like I have added irrelevant columns in beginning and its adding data of relevant columns to irrelevant columns and due to which extra columns which are relevant they are becoming null. Here Tik-Tok,Balance and Results are irrelevant column but when i select "Trim record to fit header" its taking data's from right column i.e CustomerKey,Prefix etc to left columns(which are irrelevant).I want to delete those column Re: How to delete extra columns in csv file which have no data in it Hello Aleksandar_A , Thanks for the concern,but it is not working. Please let me know if any other way is there that helps me to solve this problem. Regards, Abhishek Gupta. How to delete extra columns in csv file which have no data in it Hi,I want to delete the extra columns in CSV File which do not have data in it.While applying CSV Parser its showing that few extra columns are there.I want to delete those extra columns from CSV File.How to do that through help of Snap and Pipeline