Hello All,
Could everyone help me out to delete and append records from the same file? As a process, I have a dataset that contains Customer information, 90% of customer information flowing correctly from the system, but there are 10% of cases in which I have updated customer information in the 10-15 columns. In the dataset, I have a total of 100 columns, as standard reconciliation, I pulled out all the 10% cases in the excel spreadsheet, make changes in 10-15 columns, then remove the entire records of those customers from the Orginal file (Dataset) and copy the correct records. How do I make this process automated with the help of Alteryx flow?
In short - I have to remove the entire Customer number's old data from the Dataset and append new data from Updated Data in the dataset file
Attached is the sample data set
