Count Second appearance of Record

[priyanka08]

Hi 

I  received the monthly file like in  Jan -21 data ,I have Jan-20  and Jan-21 data .However in Jan -22 data ,I have only Jan-21 and Jan-22 data. Which leads to two entry for Jan -21  . I want to pick the Jan -21 data only from the latest file and remove the old data for Jan-21

Input

Need to create a flag =0 and then remove the row where flag =0 is mentioned

[rubenmarin · Accepted solution]

Hi, you can load fiels from the newest to the oldest in a for..next bucle, and use exists() to check if the data is already loaded.

1- Load all filenames and extract the date part as a date

2- Do a sorted load of the previous table to sort filenames from the newest to the oldest

3. Do a for i=0 to NoOfRows(FileNamesTable)

3.1 Using Peek store the filename in a variable

3.2 Load the file using the variable

3.3 In the load create a key thet identifies the data loaded, ie: Region &'_'& Date as KeyLoaded

3.4 In the where use Exists to check if the key was already loaded Where not Exists('KeyLoaded',Region &'_'& Date)

[priyanka08]

@rubenmarin thanks it worked