question

ewinkiser avatar image
0 Votes"
ewinkiser asked ShaikMaheer-MSFT commented

ADF Data Flow Concat problem....urgent...in QA...

@nasreen-akter @MartinJaffer-MSFT @KranthiPakala-MSFT

I decided to use ADF Mapping Data Flows for my mapping of an app in QA where ADF itself wasn't flexible enough with its mapping.

I am trying to do the simplest thing; just concat the 2nd column with "BCO", however I have spend several hours on this and am not successful. Please help...thanks! Mike Kiser

I have used ADF for years but just started learning Mapping Data Flows since we just got them recently in the Government Cloud......

116747-screenshot-2021-07-21-095539.jpg116765-screenshot-2021-07-21-095515.jpg


azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ShaikMaheer-MSFT commented

Do you have any column with "EmployeeId" (not employeeId) in data preview tab if you scroll to the right?

Also try with single quote 'BCO' instead of "BCO"

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Awesome...thanks! It needed the single quotes!
Mike

0 Votes 0 ·

Hi @ewinkiser ,

Glad to know your issue resolved. You also use '+' symbol to concat as show below.
'BCD' + employeeId

1 Vote 1 ·