ShaneMiller1
2 years agoQrew Cadet
Pipelines Question
Hello,
I have 3 tables within the same App:
1. Claims
2. Report Summary
3. Report Summary Copy
Thousands of claims will be funneled into the Claims table with many different company names and plan years each day. (The same company may have several plan years, which means the same company may have several different report summary records)
I currently have a numeric-formula field named [field 1] within the Report Summary table that is a query which searches for specific details within the Claims table and sums the dollar amounts. This works perfectly.
I would like to completely wipe out the Claims table at the end of each day, however, that will delete the summed values within each record housed under the Report Summary table. My thought process was to create a Report Summary Copy table, delete the query code within the numeric-formula [field 1] of the Report Summary Copy table and then create a pipeline that runs daily and essentially does the following:
SUM([Field 1]+[Field 1 (copy)])
When this process occurs, that pipeline-created-summed-value inside the Report Summary Copy table will remain in the field even after the Claims table is wiped, which will inevitably wipe all values from the Claims Summary table. I have tried to create this pipeline by using the following code:
Search a.Report Summary Table
Search b.Report Summary Copy Table
Update b.Report Summary Copy Table
Field 1 on b.Report Summary Copy Table:
{{a.Field_1 + b.Field_1}}
This brings up these 2 errors -
Validation error: Incorrect template "{{a.Field_1 + b.Field_1}}".
ValueError: invalid literal for int() with base 10: 'Field_1'
Any recommendations on another way, or a fix for this way (this way meaning the pipeline route) would be much appreciated! Thank you
------------------------------
Shane Miller
------------------------------
I have 3 tables within the same App:
1. Claims
2. Report Summary
3. Report Summary Copy
Thousands of claims will be funneled into the Claims table with many different company names and plan years each day. (The same company may have several plan years, which means the same company may have several different report summary records)
I currently have a numeric-formula field named [field 1] within the Report Summary table that is a query which searches for specific details within the Claims table and sums the dollar amounts. This works perfectly.
I would like to completely wipe out the Claims table at the end of each day, however, that will delete the summed values within each record housed under the Report Summary table. My thought process was to create a Report Summary Copy table, delete the query code within the numeric-formula [field 1] of the Report Summary Copy table and then create a pipeline that runs daily and essentially does the following:
SUM([Field 1]+[Field 1 (copy)])
When this process occurs, that pipeline-created-summed-value inside the Report Summary Copy table will remain in the field even after the Claims table is wiped, which will inevitably wipe all values from the Claims Summary table. I have tried to create this pipeline by using the following code:
Search a.Report Summary Table
Search b.Report Summary Copy Table
Update b.Report Summary Copy Table
Field 1 on b.Report Summary Copy Table:
{{a.Field_1 + b.Field_1}}
This brings up these 2 errors -
Validation error: Incorrect template "{{a.Field_1 + b.Field_1}}".
ValueError: invalid literal for int() with base 10: 'Field_1'
Any recommendations on another way, or a fix for this way (this way meaning the pipeline route) would be much appreciated! Thank you
------------------------------
Shane Miller
------------------------------