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.
I'm trying to figure out what workflow to create for a "New Record Check". Currently my workflow produces two outlooks. 1/ shows the raw data buildings only 2/ shows the updated buildings using the list in Table 2. For example, first table shows how the raw data is coming through. I'm only interested in column 3 (Building). The buildings typically come through consistently each month. However, I added in the "Unknown" record. I would like to somehow flag this record and show this record in a output file. The current way I'm checking this is copying the raw data and dumping in excel then copying the clean data and dumping in excel and comparing buildings. When there is a new record found, I manually add it to the list in Table 2. Every month there might be new data to flag. It would be nice to append the "Unknown" record above to the list (Table 2). Sorry if I sound confusing. I greatly appreciate your help. Attached is the workflow that I started and the data.