Read only rows when the values of a particular column could be a instance of type int

[Anonymous]

Hello all,

I wonder if is possible to read in load data process, only the rows in which a column could be an instance of type int, and not read them when that column cannot be converted.

For example, I have the folowing columns. I want to focus in column "Quantity":

Product name     Quantity     

A                          "50"

B                          "100"

C                          "hello"

The third value of "Quantity", cannot be converted to int.

Is possible to read only rows that could be converted to int? In this scenario, get only the firsts two rows?

Product name     Quantity     

A                          "50"

B                          "100"

Thanks a lot.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

First change the data type of column [Quantity]:

If the value of the column is not int type, error will occur

Then remove error rows:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you very much for taking your time to generate the example 🙂