top of page

Table Actions 1

Jul 9, 2024
2 min read

My boss asked me to do my first job. "Taka, there's something I want you to do, but please ask Emi for details." I immediately sent a meeting invitation to Emi and confirmed the details.


Apparently, they wanted the daily processing to extract data from the previous business day from nine files and consolidate it into a single output file.


From what I've heard, it sounds simple, and best of all, it can be done in a flash with VBA.

However, I am a beginner with AA360, and there is a possibility that something completely unexpected may happen with the previous variable specifications. I must be careful.


To summarise the contents...

The target data in one file is about 100 to 200 lines. Extract only the number of lines in the input file.

This is what happens repeatedly.

It looks like this↓


First, let's look into what kind of actions AA360 has available.

For now, what we need is something to replace the array and a loop action.


There is an equivalent to an array.



I was aware of the loop action because I had used it last time during warm-up.

If you look closely, the thing to take note of is this: a SQL query??? Seriously, can I use SQL?


I think I can do something.

To begin with, I decided to experiment by creating a table in Excel and checking whether it would load properly.

When we actually tried incorporating it into our development, we didn't realize it would be quite a hassle...


Although it was eventually completed, there are some points to be aware of regarding table variables, and there are still some things I haven't been able to resolve.

I will write about that next time.


Comments


bottom of page