11. Examples of wildcard pattern in copy activity of ADF

[@meghachouksey3248]

If we want to skip files which contain char like fact, aggregated inside the file name like data567- fact.csv and data13144-aggregated-1456.csv from copying how we can do this???

[@nikhilchandragiri8132]

Thanks for the video, it helps but one more question? How to consider files which has filename with only numbers as postfix (ex: filename0, filename1, filename200)

[@azurecontentannu6399]

You can use filename*

[@itadorisenpai1075]

wht will happen if we used *.*?

[@tulaaddis]

thanks for your videos . really appricated . if i have txt file it ends in coma in column header , how can i remvoe the comma at the end of column since adf expect the column name .it throws me error

[@azurecontentannu6399]

Use dataflow . Add source transformation and while importing schema, uncheck first row as header. So now your column name is the first record. Use conditional split and divide the entire dataset into two parts. One-First record(colname) , Two-All other records. Perform derive col transformation on first branch and remove the comma and then union transformation to concat all data back.

[@tulaaddis]

❤ wow. Great I will try it. Do you give online classes? Please let me know. Really appreciate your help Thank you!

[@sudarshanthota3369]

How to take only files which contain data_currentdate.csv?

[@azurecontentannu6399]

You can make it dynamic : @concat('data_' ,*, formatdatetime(utcnow, 'yyyyMMdd').csv)