Distinct in blob storage

Question

Vineet S 1,390

Hi how will get distinct product code from blob storage contains rows p1, p2, p1 .. Please share screenshot

phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-08-12T17:57:27.29+00:00

@Vineet S Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-08-12T17:57:27.29+00:00

@Vineet S Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

1st step is to use lookup activity as seen below:

And then you can use the array and take union of that array to avoid duplicates and get unique values:

Vineet S 1,390 Reputation points

2024-08-12T20:45:22.2933333+00:00

Can you share screenshot for array
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-08-14T18:01:42.06+00:00

@Vineet S
please check below screenshots
phemanth 15,755 Reputation points Microsoft External Staff Moderator

2024-08-16T15:13:05.2+00:00

@Vineet S Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.