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.
Hi,
I just to run a new report that can give just the information with the flag in 'Y', but keeping Columns and Account number and also that can give the information in the column called New Agent DBA name, any thoughts?
Account Number | Previous Agent (DBA) Name | New Agent (DBA) Name | Location Name Changes? |
AAT005222 | 1 | 2 | Y |
AAT005255 | 4 | 5 | Y |
AAT005266 | 4 | 6 | Y |
AAT005277 | 4 | 7 | Y |
AAT005288 | 4 | 8 | Y |
AAT016123 | 4 | 9 | Y |
AAT019632 | 4 | 4 | N |
AAT019632 | 4 | 4 | N |
AAT036219 | 4 | 4 | N |
You'll need to provide some more information so we can help you. Is the example you've provided your target data structure? What does the source data look like?