topic Count Second appearance of Record in App Development

Count Second appearance of Record

priyanka08 — Thu, 22 Sep 2022 07:43:23 GMT

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

Re: Count Second appearance of Record

rubenmarin — Thu, 22 Sep 2022 09:01:06 GMT

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)

Re: Count Second appearance of Record

priyanka08 — Fri, 23 Sep 2022 11:36:45 GMT

@rubenmarin thanks it worked