[PYTHON] IQ Bot Custom Logic: Fixed Value Assignment

Use IQ Bot custom logic such as Replacement and Retrieve Number Infrequently, "Fixed value assignment" is surprisingly powerful.

Fixed value substitution

Regarding the assignment of fixed values, the process itself is very easy, so I think that explanation is almost unnecessary.

Fixed value assignment (field item)


field_value = "Fixed value you want to assign"

I think there are many people who ask, "When do you use this kind of processing?", So I will write it.

Usage 1: Output the classified group

IQ Bot has a function to automatically classify forms by default, and AI classifies forms of the same instance by format.

Such a feeling ↓ グループ.jpg

You may not be able to see the contents of the form because you cannot see it, but Group1 and Group2 have their own images. The forms that say "The format is different but the items you want to retrieve are the same" are grouped together.

In terms of image, Group1 is the invoice of company A, and Group2 is the invoice of company B.

Since both are invoices, the items you want to retrieve are the same, but the formats are different, so they are in different groups.

When the process is complete, the CSV will be output to one folder for each instance, regardless of the group.

In other words, when the processing is finished, it is not possible to know which group was classified and processed.

There is no particular problem for people who say that's fine, but if you like "I definitely want to know the group I came to!", Create an item such as "Processing group" when setting the item, and enter the name of the group by fixed value assignment for that group.

The "processing group" of Group1 has field_value =" Group1 " The "processing group" of Group1 has field_value =" Group2 "

It is an image of embedding logic in the same way.

Usage # 2: Setting items that are uniquely determined based on the classification

It may be essentially the same as usage 1, but I think it is mainly used in practice.

As in the previous example, consider Group1 to be Company A's invoice and Group2 to be Company B's invoice.

In this case, suppose that the reading items include items such as "Billing company name", "Billing address", and "Remittance destination account number".

To be honest, all of these items are output based on the OCR reading results. OCR is never 100% accurate.

The fact that it was classified as Group 1 means that the "billing source company name" is known to be company A, Because I used the result of OCR, noise was mixed in and it became like "\ A company" It is possible that a slight blurring of the print will result in "Company H".

In addition, there are cases where it is difficult to read the company name column etc. with OCR due to the overlap with the imprint.

For such items, it is also possible to enter a fixed value with custom logic without using the OCR result one by one.

important point

When adopting the second usage, it is necessary to fully verify in advance whether ** the automatic classification of IQ Bot can be used as the basis for fixed value assignment **.

In other words, there is a company called company X that issues invoices in a format very similar to company A. Isn't that company's invoice inadvertently classified as Group1?

Summary

--Using fixed value substitution, you can: --Part 1: Output the processed group --Part 2: Fixed values are entered for items that are uniquely determined based on the classification. ――When using the second method, make sure to verify in advance whether the classification can be used as the basis for fixed value assignment.

Recommended Posts

IQ Bot Custom Logic: Fixed Value Assignment
IQ Bot Custom Logic Basic Key
IQ Bot Custom Logic Related Processing Summary
IQ Bot Custom Logic (Python): Streamline exclusions in loops
IQ Bot Custom Logic: Correcting common reading habits on dates
IQ Bot Custom Logic (Python): Efficient replacement process in a loop
IQ Bot Custom Logic (Python): Efficient replacement process in a loop
IQ Bot Custom Logic: Delete the last n rows of the table
IQ Bot Custom Logic: Split Application (Apply to Table, Include Error Control)
IQ Bot Custom Logic: Correction of garbled characters with fixed patterns, blank filling, format conversion, noise exclusion (replacement processing)
IQ Bot Custom Logic: Split (extracts only bank and branch names from account information)