Forum Discussion

amol0512's avatar
amol0512
Helper I
2 years ago

Find out Cleared Transactions Reconciliation based multiple dates

I am using multiple datewise excel files and trying to find out  No of Cleared transactions (Cleared Transactions=Transactions which are not appearing next day). I have current approach as per below ...
Need Help
amol0512's avatar
amol0512
Helper I
2 years ago

dufoq3,

 

It's working but it takes long to refresh. it's already 45 minutes but hardly 7-8 files are refreshed. (BTW I am not loading Shifted column that contain shifted tables)

 

 

dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi,

  1. how big are your source excel files?
  2. I'm don't understand what do you mean that you are not loading "Shifted column that contain shifted tables"
  • amol0512's avatar
    amol0512
    Helper I
    2 years ago

    Files are not too big on an avg 2000 kb each file. 

     

    Shifted column.

     

    • dufoq3's avatar
      dufoq3
      Community Champion
      2 years ago

      Could you upload 3 or 4 of your tables i.e. to google drive and send here a link? Don't forget for permissions. If there are not sensitive data. If there are delete sensitive data please

      • amol0512's avatar
        amol0512
        Helper I
        2 years ago

        Hi, Data is very sensitive hence can't share with anyone but it's very similar to what you have prepared.