question

ramtohulritesh-5347 avatar image
0 Votes"
ramtohulritesh-5347 asked ramtohulritesh-5347 commented

Mapping data flow : how to access individual items returned by columns()

In Mapping data flow we have the expression function columns() which returns the content of the current row. The data type returned is Any.
The only way to access each item, that I could find, is to convert the result to an array first and use [index]. However, when we have different data types, I need to convert the result to string first, then to an array.

So I use something like this:
Array(toString(columns()))[index]

I am just wondering if there is a simpler way to access each item without doing the conversions ? Maybe some syntax I missed...

azure-data-factory
· 3
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.

Arrays can only have homogenous elements of same type. What is the end result you are trying to achieve?

2 Votes 2 ·

@ramtohulritesh-5347 are you still in need of assistance?

1 Vote 1 ·

Hello, its ok, am using the code I wrote above and its working fine. Thanks for your help

1 Vote 1 ·

0 Answers