Table Builder - Concatenate

Discussion & Feedback for Jet Enterprise
a1becker
Posts: 13
Joined: Fri Nov 09, 2012 9:40 am

Table Builder - Concatenate

Postby a1becker » Mon Oct 17, 2016 10:07 am

I am trying to Concatenate two Text fields within the Table Builder. Here is my current formula.

=NP("Formula","CONCATENATE([@[No.]]," - ",[@[Name]])")

The result when I run the Table #VALUE!

The result I am looking for is 1000 - Customer ABC

I have tried so many variations of this formula and cannot find the correct one. What am I doing wrong??

User avatar
CCJetXP
Posts: 82
Joined: Wed Oct 01, 2014 11:39 am

Re: Table Builder - Concatenate

Postby CCJetXP » Mon Oct 17, 2016 3:58 pm

Hello A1becker,

Please see a similar Community posting with an answer in the below link:
viewtopic.php?t=4478

Cheers,

a1becker
Posts: 13
Joined: Fri Nov 09, 2012 9:40 am

Re: Table Builder - Concatenate

Postby a1becker » Tue Oct 18, 2016 6:53 am

Thanks for the link. I did "scour" this site for answers before I posted my question. That is why I copied the exact formula I entered into NAV. I am wondering if I am just missing some "," or ")" and do no see it.

Thanks,

krd1996
Posts: 16
Joined: Mon Jan 05, 2015 10:57 am

Re: Table Builder - Concatenate

Postby krd1996 » Tue Oct 25, 2016 8:21 am

A1becker,

Did you get this resolved?

When I create this formula in Table Builder, I get the following:
=NP("Formula","concatenate([@[No.]],"" - "",[@[Name]])")

This produces your desired results. Compared to your formula, mine has double quotes around the dash (-) where yours does not.

Regards

a1becker
Posts: 13
Joined: Fri Nov 09, 2012 9:40 am

Re: Table Builder - Concatenate

Postby a1becker » Tue Oct 25, 2016 10:13 am

krd1996,

thanks for the suggestion but I still get an error message. first I added another set of ("). That did not give me the correct results. Then I copied your formula and popped it into my Table. Still did not get the desired results.
jet error.jpg
Thanks for any suggestions you may have for me.

JET-btr
Posts: 164
Joined: Thu Jun 19, 2014 4:09 pm

Re: Table Builder - Concatenate

Postby JET-btr » Thu Oct 27, 2016 9:54 am

The formula, when in Excel should be =NP("Formula","CONCATENATE([@[No.]],"" - "",[@[Name]])") with double quotes surrounding the -.

mariareese
Posts: 1
Joined: Fri Jun 16, 2017 12:09 am

Re: Table Builder - Concatenate

Postby mariareese » Fri Jun 16, 2017 12:19 am

formula is working win 10 but not in win 7 .. I think you should try win 8 or win 10 to work as well.


Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 1 guest