Forum Discussion

jojig_allot9's avatar
jojig_allot9
New Contributor
2 years ago

Text file to csv files (Many to Many) from folder

Dear Experts, I'm trying to read text files from a folder and i need to create csv file in target file location. For Example: i have 3 .txt files in a source folder and i need to create 3 .csv file...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
12 months ago
Copy LinkReport

samuelrz 

You can go with Salesforce SOQL or Salesforce Read Snap, using both snaps you can apply multiple conditions in the WHERE clause. 

"AccountId =  '" + $AccountId + "' 
AND Product_Need__c = '" + $Product_Need__c + "'
AND CreatedDate = LAST_N_DAYS:90"

In your case, I will go with following approach: 

  • Read CSV file
  • Read all Opportunities from Salesforce created within 90 days
  • Match records from CSV file and Salesforce using Join Snap
Related Content