topic Re: Concatenated column within table in App Development

Concatenated column within table

martynwb — Sat, 16 Nov 2024 17:35:17 GMT

Hi all,

I need some help please.

I have three source tables: Asset, Component and Assessment. An asset is related to multiple components and an assessment is linked one a single asset.

I've displayed a number of fields in the table from assessment and asset. I would like to add a column with all of the related components but I can't figure out how to do it. It's always displays as blank.

Any ideas would be greatly appreciated. I've attached a screenshot.

Re: Concatenated column within table

Ksrinivasan — Fri, 22 Jan 2021 17:54:22 GMT

hi,

any common field are available in both field?. supposed to be that common field should have value.

ksrinivasan

Re: Concatenated column within table

martynwb — Mon, 25 Jan 2021 09:24:12 GMT

The issue seems to be that there are common fields between asset and component and asset and assessment but not directly between assessment and asset. That is the linkage that I need to incorporate.

Re: Concatenated column within table

Ksrinivasan — Mon, 25 Jan 2021 11:19:41 GMT

hi,

pl, explain how you are going to link by manually that two tables,

ignore script,

is there any Master type of third table required to join?

ksrinivasan.