question

RohitKulkarni-0411 avatar image
0 Votes"
RohitKulkarni-0411 asked MaheshKumarSSM-8330 commented

Need to delete the records from Txt file in Blob storage

Hello Team,

I am trying to delete the records from txt file in Blob storage via Azure data facotry pipeline.Please advise me

Regards
Rk

azure-data-factoryazure-blob-storage
· 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.

What have you tried so far and what is not working?

0 Votes 0 ·

Hello Sam,

I need Removes data from the pool. Whether this can be possible if yes, How.

What i see is we can delete the file. But not the records from txt file.

Regards
RK

0 Votes 0 ·
MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered

In ADF, add a new Data Flow. Point to your text file in the Source transformation, then add a Filter transformation to filter out the rows that you wish to delete. Add a Sink transformation to write a new file without your deleted rows.

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.

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 answered MaheshKumarSSM-8330 commented

This issue got resolved by applying in different format via azure function.

Thanks for your help Mark.

· 1
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.

Hi Rohit,

Could you please explain in detail the changes you made? I too have a similar requirement.
Thanks.

Regards,
Mahesh

0 Votes 0 ·