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?
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
how to get the same first column value from a file by using copy data activity and how to get the second row or third row also
thank you, saved me alot of frustration on why the entire dataset wasn't being returned because I had firstrow selected.
Welcome
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?
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
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