Apply one specific value to all rows

[#1]

I need to add a single value for each and every row (EOD_ADJ). But when I try to join all I get is a bunch synthetic keys.

Any ideas how to do it?

LOAD Distinct
      [INSERTION DATE],
     TIME,
     [FLOW TYPE],
     AMOUNT,
     date([FLOW EFFECTIVE DATE]) as [FLOW EFFECTIVE DATE],
     date([FLOW MATURITY DATE]) as [FLOW MATURITY DATE],
     Date([FLOW EFFECTIVE DATE] + IterNo() -1 ) as DATE,
     TEXT
FROM
[Log 2.1.xlsm]
(ooxml, embedded labels, table is TRANSACTIONS)
While [FLOW EFFECTIVE DATE] + IterNo() -1 <= [FLOW MATURITY DATE];


Right join LOAD
     I AS EOD_ADJ
FROM
[Log 2.1.xlsm]
(ooxml, no labels, table is [Holidays Etc])
WHERE RecNo() > 1 AND RecNo() < 3; 

[alexandros17]

Try with a Left Join and let me know

[#3]

When trying left join, same result occurs, from what I can see..

[alexandros17]

There is a very simple way:

LOAD Distinct
      [INSERTION DATE],
     TIME,
     [FLOW TYPE],
     AMOUNT,
     date([FLOW EFFECTIVE DATE]) as [FLOW EFFECTIVE DATE],
     date([FLOW MATURITY DATE]) as [FLOW MATURITY DATE],
     Date([FLOW EFFECTIVE DATE] + IterNo() -1 ) as DATE,
     TEXT,

     'I' AS EOD_ADJ

[#5]

Thanks Alessandro

'I' AS EOD_ADJ is loaded from another sheet and it is a single cell, not a table.

So Im not sure how you mean

[swuehl]

You don't get any synth keys without the last join?

Could you post a screenshot of you data model and your script or document log?

[#7]

As I can see from where condition, it's a single value so you can store it in variable and then add with table.

[alexandros17]

But the value for I is Always the same, isn't it?

It is a unique value, a constant?

[#9]

No It changes every day unfortunately

[alexandros17]

Ok but when you try to add the new column to the table the value is only one?