16. Lookup Activity Read file from ADLS first row only

This video covers Lookup Activity - Read file from ADLS first row only

[@sharathhemmadi6293]

I need to read an excel metadata (Column name, type & length - length of a biggest entry in the column) and use that to create tables dynamically. Can this be done?

[@rajashekar4171]

Hi, I have one doubt like, In set varible we have create one variable and in output we are geeting only city name that is PUNE instead of this if we choose data type Array in Set varible, instaed of string we will get output for all columns ? like ID,Name, City etc in output section ? can we use or not?? Thanks

[@gudiatoka]

No ,as look up return in json format but what to say is array . data type mis match . i tried ur logic but it failed