Return Summarization table to the previous table

talebi

Forums

Hello,
I summarized my data based on Supplier_Name and Transaction date from a table with lots of fields (columns). So we can see the number of records and the summation of billing amount in 2 new columns. If I click on each value in NO_OF_RECS column, I can see the extraction previw which shows all the information for all columns in the table we got summarization from. it is exactly I am looking for. My question is: How can I extract all these extraction prevew for all rows at the same time in a new table. I need all these info in a new table for all rows. I tried Visual Connector to merge this table with the one I got summarize info from to have all the information in one table but the problem is we do not have unique index column to merge on. So in Visual Connector I cannot define two or more index. Is there any way to extend this table and have all the columns from

Brian Element Tue, 11/30/2021 - 10:35

Are you looking for a separate file (database) for each key grouping?  If so check out the key value extraction function as that should do what you are looking for.  The key value is limited to 500 unique key pairs, if you need more look in the IDEAScripts section as there is a script that will extend this beyond the 500 unique keys.

talebi Thu, 12/02/2021 - 15:16

No I am not looking for a separate file for each grouping, I am looking for a separate file for all groups at the same time. For instance, Princess Auto 07 on 2021-05-21 has 2 records and so an for Canadian Red Cross on 2021-05-27. This summarization came from Table 1. So I am looking for all the information of each summarize row from Table 1 in one Table. How can I do that? I know I can do it by use join function, but I was wondering if there is any other way!