Finance | Project Operations, Human Resources, ...

Answered

How to concatenate two fields data into one fields in query in D365FO

(1) Share

Report

Posted on by CU21091228-0

230

Hi Team,

I am having two table.

TableA and TableB

TableA i am having 2 fields

Field1

Field2

TableB i am having 1 field

FieldZ

Below should be the output

TableB.FieldZ = TableA.Field1 + TableA.Field2

Below code i am using.

 qbdsTableA = query.addDataSource(tableNum(TableA));

 qbdsTableB = qbdsTableA.addDataSource(tableNum(TableB));
 qbdsTableB.addLink(fieldNum(TableA, Field1), fieldNum(TableB, FieldZ));

Please let me know how to achieve this.

Categories:

Microsoft Dynamics AX

I have the same question (0)

All responses (4)

Answers (1)

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Do you want to set the FieldZ on Form? or do you want to query already existing data on the form?

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report
I am running a batch job.

After while (queryRun.next())

{

// Here i will get TableB records

}

Actually in below i have to set something like + Field2

qbdsTableB.addLink(fieldNum(TableA, Field1 + Field2), fieldNum(TableB, FieldZ));

It can be achieve using while select

while select TableA where TableA.CusAccount == '000' Outer Join TableB where TableB.FieldZ == TableA.Field1 + TableA.Field2 { }

Please let me know how to achieve using query.

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

It's impossible, but a workaround exists. Create a view with TableA as a data source and create a computed column concatenating Field1 and Field2. In your query, join this view with TableB.

Nevertheless if using your tables is difficult like that, it suggests that your data model isn't designed correctly. Consider fixing the data model, rather than just a single query. In this case, it seems that FieldZ violates the first normal form: it isn't atomic.

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to concatenate two fields data into one fields in query in D365FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to concatenate two fields data into one fields in query in D365FO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates