Question

Lookup

  • 31 March 2019
  • 2 replies
  • 4 views
perry
Badge +2

Hello,

 

I've studies lookup solutions but Iit still does not work.

I have 2 ora-tables.

 

- a lookup table KALENDER with DATE_START and DATE_END and a corresponding number ie

 

DATE_IN DATE_OUT PERIOD

 

20181101 20181124 10

 

20181125 20181212 11

 

20181213 20181215 12

 

20181216 20190114 13

 

20190115 20190125 1

 

20190126 20190228 2

 

20190301 20190310 4

 

20190311 20190322 5

 

- a table with a dossiernumber and a DATE_INVOICE.

 

DOSSNR DD_INVOICE

 

D099 20181120

 

D099 20190305

 

D125 20190127

 

D125 20190315

 

D127 20190306

There are more invoices per DOSSNR / YEAR.

 

The output should be like:

DOSSNR YEAR_2017 PER_2017 YEAR_2018 PER_2018 YEAR_2019 PER_2019

 

D125 2019 2,5

 

D127 2019 4

 

D099 2018 11 2019 4

 

Can you help me?

2 replies

takashi
Rank
Userlevel 2
Badge +17

The InlineQuerier and some transformers might help you. For example, this workflow

generates this table.

In your output table, it's unclear how the field values should be corresponding to the header (field names), so the workflow above is not completed yet.

Could you post your desired resulting table again with the "Insert Table" function?

perry
Badge +2

@takashi

Thank you very much, your solution is sufficient and I have the desired output.

Reply


Community Stats

28,681
Posts
109,410
Replies
36,542
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.