0

I have created a dataflow using row_number and I want to extract only the values where row_number = 1, but I can't get it to work. Please tell me how to do this.

image

#azure #synapse #dataflow

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11
otaku
  • 1
  • 3
  • can you provide some more information regarding this?? – Pratik Lad Dec 05 '22 at 09:39
  • It was created with reference to this page. https://learn.microsoft.com/en-us/answers/questions/419209/additional-column-that-records-the-row-number-auto.html I want to extract values with column row_number = 1 only. – otaku Dec 06 '22 at 03:14

1 Answers1

0

I want to extract only the values where row_number = 1

To filter rows based on column value we have two ways:

  1. Filter
  2. Conditional split

My Sample data after windows transformation

enter image description here

Filter transformation

In Filter settings give Filter on as column name with particular value. Here I provided RowNumber == 1 so it will only filter rows where RowNumber =1.

enter image description here

Output of Filter transformation

enter image description here

Conditional split

In Conditional split settings give Split condition as column name with particular value. Here I provided RowNumber == 1 so it will only filter rows where RowNumber =1. enter image description here

Output of Conditional split transformation

enter image description here

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11