Hi Folks, Looking for a condition to merge the following example. Table A ID1 2 345ABC Table B IDID Alias7A8B9C Table A and Table B are joined (Join columns not illustrated here.) Now, I would like to have a column with all numerics in one column(ID_Numeric) Thanks in advance

Help with condition

Hi Folks,

Looking for a condition to merge the following example.

Table A

ID
1
2
3
4
5
A
B
C

Table B

ID	ID Alias
7	A
8	B
9	C

Table A and Table B are joined (Join columns not illustrated here.)

Now, I would like to have a column with all numerics in one column(ID_Numeric)

Thanks in advance

Workflow

Regex

Accepted answers

atcodedog05

Hi @Arcane

Does this work

Hope this helps : )

replace values.yxmd

All comments

TheOC

Hi @Arcane

sorry just a little confused what you are requiring, please can you show an example output of what you need?

IF you just need all ID's concatenated, you can use the summarize tool for that, and then append it to every record.

Cheers
TheOC

Arcane

@TheOC- That was quick!

The sample output would look like this,

1
2
3
4
5
6
7
8
9

I have been writing the condition using IIF, but failing to achieve it.

Can we do it using a conditional formula?

TheOC

hey @Arcane

haha, yeah saw your question as soon as i loaded the community!

I think this is what you need, please have a look and let me know.

Thanks,
TheOC

arcane.yxmd

TheOC

Hey @Arcane

Are you able to provide a larger data sample showing what you mean?

Thanks,
TheOC

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703