one problem is that your above concatenate won't add any values for field Override to your data model and inputfield needs these values set with a select or load to use as placeholder for subsequent modification.
So it should look at least like this
CONCATENATE(REPORT_FXRATE) LOAD * INLINE [
Now you have got a value, but creating a table box (or using the table viewer CTRL-T) of your table you will see that concatenation is not what you want, it just adds a row, but you don't get your new value really connected to the preexisting values for Rate and Currency, the records of your concatenated table and the original table keep being separated.
You could use a cross product to add value in field Override to each existing record, maybe like this
JOIN (REPORT_FXRATE) LOAD * INLINE [
But now the new field (and neither the other two fields) seems not to be usable as inputfield, even when I do a resident reload of the whole table.
Here is where I am stuck also, so I think I can explain why your approach does not work, but I can't really resolve your problem at the moment.
maybe this could work out:
Do a second resident load of your currency table after you did the binary load, like
LOAD * CurrencyID, USDRate as Override resident REPORT_FXRATE;
So you get Override linked to your data model via CurrencyID, and this has also the advantage that your Override values are preset with the rates loaded from your database.
Hope this helps,
Thanks for your help Stefan. You put me on the right track. I had to slightly change your suggestion above and reload from the qvd into a new table to get the input field to work as below:
INPUTFIELD [Override USD Rate];
,0 as [Override USD Rate]
When I loaded from the resident table it would not recognise the input field for some reason.
Again I really appreciate your help. You saved me some frustrating hours.