Finance | Project Operations, Human Resources, ...

Concatenate two or more fields in computed column in view D365fo

(0) Share

Report

Posted on by Zohan_93

199

Hi All,

I've a scenario where i've to concatenate two or more fields on computed column of view. How would it be possible. Any suggestion ?

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

Look at MS Docs, the example given is of concatenation:

docs.microsoft.com/.../walkthrough-add-a-computed-column-to-a-view

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Hi Zohan 93,

You can use SysComputedColumn::add. Please check the sample code below -

public static server str stingConcatenate() { return SysComputedColumn::add(SysComputedColumn::returnField(tableStr(View1), identifierStr(table_1), fieldStr(table1, Field1)), SysComputedColumn::returnField(tableStr(View1), identifierStr(table_1), fieldStr(table1, Field2)) ); }

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Zohan,

Here is a share：community.dynamics.com/.../how-to-concatenate-two-fields-get-from-view-with-hyphen

More about SysComputedColumn: docs.microsoft.com/.../gg945162(v=ax.60)

Was this reply helpful? Yes No
Zohan_93 199 on at

Like (0)

Report

Hi Gunjan, I need to concatenate two string fields. not adding them

Was this reply helpful? Yes No
Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

What's the difference?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Zohan,

Adding string fields is equivalent to concatenating them. Did try writing a method for the computed field this way?

Was this reply helpful? Yes No
Zohan_93 199 on at

Like (0)

Report

Yes I've tried it but when ever i tried to use the keyword hyphen "|", it throws an error on build.

Anyhow i've tried Concat keyword but this shows me in this format, need to add hyphen after dimension change

below is my result i'm getting using Concat:

Branch20Department65MainAccount511301Segment54BusinessUnit02

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
You can try using SysComputedColumn::returnLiteral -

SysComputedColumn::returnLiteral("-"),

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,948 Most Valuable Professional on at

Like (0)

Report

Do you have any particular reason to implement your own solution for dimensions instead of using the standard one? You can check LedgerJournalLineEntity, for example.

Anyway, the result seems to be what you asked for. If you want to add a delimiter, you could utilize CONCAT_WS() instead of CONCAT(). But you shouldn't - you should use the standard solution, which also respect the standard separator defined in parameters.

Was this reply helpful? Yes No
Zohan_93 199 on at

Like (0)

Report

the add functionality accepts only two arguments. i've to write my own custom method for this ? i guess

Was this reply helpful? Yes No