Hi @Shrutii The SQL JOIN is used when we have to extract data from more than one table.The SQL UNION is used when we have to display the results of two or more SELECT statements (from tables). In the case of SQL JOINS, the records are combined into new columns.In the case of SQL UNION, the records a...

The suppression file(having CID) is getting generated from another system (or client manually creating it). Ask them to put it in SFTP location with a predefined name (naming convention and rules are important), like supressionFile_xyz_ <date_of_creation> You can schedule your workflow (once in a da...

Hi @Akila4, As mentioned by @AkshayAnand also above, how you will access the json file, you need to upload this file into SFTP before operating on it. Once this is done, you can access it from SFTP in the js activity, parse it and save the data in a table. You don't need to load it using data loadin...

Hi @J2021 ,You can use test activity before your split activity, and only pass it through if recCount is more than 100In condition put vars.reccount >100False condition, you can route to another flow. Hope this helps Regards,

Hi @rvnth,As mentioned above, you need to request and keep the file in SFTP (best if client have some process to generate and load file in that SFTP location) to automatically pick by campaign worfklow.If that is not possible, then you have to manually load the file using Data loading activity. For ...

Hi @dmoorethree ,Yes you can use split activity (as shown below) to split incoming population segment 50:50.Use random sampling to randomly select 50% pollution and other 50% randomly selected as its complement. (Don't forgot to enable complement checkbox).  Regards,   

Hi @DishaSharma ,If I understood correctly, you need to know what condition you can put in your query activity.You can put anything like 'campaignCode' is equal to '<code of campaign>', so that you get only those record which you want in the result.Please write back, if you are facing any other chal...

Hi @rvnth, As you mentioned above, you are receiving a suppression file with CID via email on daily basis. Can you please ask client to share this file over SFTP (instead of email), this way you don't have to upload it manually to SFTP or Adobe workflow. If you are manually uploading it every day (o...

Hi Akila,Seems like you haven't provided proper path of json file in your javascript activity (code).File path is a parameter for java script code or function you have in javascript activity, please check.  Regards,

Hi Ratika,You can run it with execCommand() in js activity in campaign classic workflow.Pleaser refer Campaign classic documentation for more details Regards