Mapping: multiple cells to yaml

[deLuXe83]

Hi,
first, thanks for this great project!!

I am playing around a bit and the question came up, if it is possible to assign multiple cells of the ods template to a single reference in the yaml file? Liek the "VERKETTEN" function in excel?

Thank you!

[gflohr]

This is not possible and I think I won't add that feature because the workaround is really simple: Use the CONCAT/VERKETTEN function in a hidden cell (outside of the print area) and reference that hidden cell in the mapping.

In general: The spreadsheet app has many more functions than just CONCAT/VERKETTEN, think of rounding, changing case, arithmetic, and so on. IMHO, it does not make sense to re-implement that inside the mapping logic because the spreadsheet application does a much better job at this.

[deLuXe83]

Hi thx for your reply.
Understood, that workaround indeed is simple and useful IF you use the spreadsheet.
in my usecase, my goal would be not to use the spreadsheet, because i want to map a CSV file, which i will get from another API. in this CSV only the line items are present, all other infos i would like to hardcode on the yaml.
point is, in this CSV there is more information available then "fields" in the yaml (eg. additional information to the line items, that is not part of the official X-Scheme)... and i do not wnat to loose this information. and therefore combine it in for example the "line description" field :)
Having the workaround would mean, somehow (in best case fully automatically :)) switiching/mapping the CSV file to the spreadsheet file and then mapping the spreadsheet file via the yaml

[gflohr]

I see. But re-implementing formulas in the application would imho still be mission creep. So you probably have to implement some kind of filter that does concatenation to get that flying.

[deLuXe83]

understood :)
thx anyway