This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Please see attached file for visual demonstration.
I have two files:
1. has keycodes for my campaign with customers who received the campaign
2. has purchases that were between certain time period (these include people who may or many not be in the campaign file)
I joined these two. I got the joins and it's all good. BUT now I want to do some predictive analytics on this. To do that I need to have binary field 'yes' or 'no' to determine if someone made a purchase or not and that is based on 'this customer was sent an email and he/she made a purchase so say 'yes' or vice-versa'.
I thought that I could create a field in the workflow that says 'yes' or 'no' rather than taking the files into excel and then doing the manual additional of a colum etc. etc. for all these files.
Is it possible to do what I am asking for or do I need to take the files into excel and then add the response?
If you see the word document that I attached, there is the Left join that has all the people who didn't purchase, the middle 'Join' has everything that joined from my two original files and then the R is all the people who didn't join either so basically were not part of the 'Join' or purchased but weren't sent the email.
I just want to add 'yes' and 'no' to these separately.
The Generate Rows tools does basically what is says...generate Rows (as opposed to a new field which is done typically with the Formula tool...although there are other tools like the Multi-Field and Multi-Row Formula tools that can also create new fields for specific reasons).
The Generate Rows tool is primarily when you are wanting to create a set of records that might be missing (for example, a record for each date in the year) and you want to "fill in the blanks". Or another case is when you have no data but want to work with some records of data for testing a workflow, it is a quick way to generate some random numbers (but again, you would generate the rows with the Generate Rows tool, and the extra fields with the Formula tool).
Hi akaur! Just add a formula tool to each of the 3 outputs from the Join. Make sure you give your new field the same name in each of the new Formula tools! Define your Yes and No in each as appropriate and then use the Union tool to bring all three pieces back together!