Concatenating two values

Get Help & Discuss AutomationEdge UI
1

How to Concatenate Values into two different Colum’s into single Colum.
EX
image

LoanNoDR by concatenating two values from LoanNo and Dr Column as Loan No-Dr
Eg : 2301-560

2

@Pratap_Bhosale

Concat Fields plugin step can be used to achieve the use case.
I’ve attached the screenshot of the workflow for your reference.

  • Workflow:

Image1
Image1931×623 17.6 KB

  • Excel Input:

Image2

3

thanks @KalyaniW

4

and what if we have multiple columns to concat ??

5

You can use the same plugin step Concat Fields and select the columns you want to concat in Fields Tab.

6

can u plz show me with example unable to do it

7

a) LoanNoDR by concatenating two values from LoanNo and Dr Column as Loan No-Dr
Eg : 2301-560
b) LoanNoCRAMT by concatenating two values from LoanNo. And CRAMT column
LoanNo-CRAMT
Eg : 3456-800
2. Compare the two values “LoanNoDR” and “LoanNoCRAMT” and write data in new file

8

I’ve attached the sample workflow for the same. Refer to the given workflow for your use case.
Sample Excel:
Concatenate.xlsx (8.4 KB)

Workflow:
WF_Concatenate.psw (25.0 KB)