Help with condition

[Arcane]

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

[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

[atcodedog05]

Hi @Arcane 

Here is my take using find and replace tool. Find and replace works like excel vlookup but it accepts only string values as keys hence I am converting to string and performing the replace.

Hope this helps : )

[Arcane]

I think I should have given more detail to the problem statement. Your solution works but not for the particular situation, as it does a merge but wouldn't work as expected when other columns are in the picture. The mapping goes wrong. My bad for not able to put it in whole :) Thanks, man!

[TheOC]

Hey @Arcane 

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

Thanks,
TheOC

[atcodedog05]

Hi @Arcane 

Would mine work if not please provide sample data and expected output.

Happy to help : )

[Arcane]

@atcodedog05, your solution helps! but, REPLACE tool replaces within the same column. If I am looking to have this data in a new column, it shall add another step of replicating the column first and perform a replace.

Instead, I have written the following in Formula but not working as expected. I have all of the considering columns converted to String in the previous step.

IIF(([ID]) = ([ID_Alias]), [Right_ID], [ID])

[atcodedog05 · Accepted solution]

Hi @Arcane 

Does this work

Hope this helps : )