Combining a number and letter column when there are blanks mixed in

Help StudioX
, ,
1

Hello Everyone.

I am trying to combine data from 2 columns in Excel into a 3rd column. One Column is numbers and the other is letters. My number column always has data but my letter column doesnt.

Currently I am using a “For Each Row” loop with a “Write Cell” Activity. I am able to get this to work when my Number and Letter both have values, but it leaves it blank when there is no letter value.
This is my expected out put:
image

This is what I am getting:
image

This is the loop I am using:
image

This is what is in my Write Cell:
image

In Excel I can type the formula “=A2&B2” into C2 and get the correct information, but I cannot get the & to work when I try in studiox.

What can I do to get the correct data I need?
Thanks for the help.

2

Try the =concat(A2,B2) formula or =concatenate(A2,B2) . Which one you have in your excel depends on your version of excel

3

Hey

what about the following?

image
image423×758 32.7 KB 

CurrentRow("NumberLetter") = CurrentRow("Number").ToString + CurrentRow("Letter").ToString

image

Regards

4

I dont have an “assign” activity for inside the For Each Row in Data Table.

5

Hey @Marc_Sciarrino ,
You can try this.
Testing1.xaml (8.4 KB)

Please mark this as solution if it helps you…

Regards,

6

Hey

You should drag and drop it

Regards