Having a problem for Importing Excel file.

[Mark Pastoril]

I have a Import button on my layout that will import excel file ,

it works well ,but the problem is when importing the file is that it also imports the blank data from the excel.

It will add up to my space every time i will use this function, and it will cause problem someday.

I don't want that to happen, So please help me for excluding the blank data to my filemaker application.

[comment]

It is hard to advise with so few details. In general, you can either fix the source file or validate one of the target fields as not empty, validate always. This should prevent the import of empty records - if that's what you mean by "blank data". Alternatively, you could follow the import with finding empty records and deleting them - but that would be an inferior solution, IMHO.

 

Edited March 16, 2020 by comment

[Mark Pastoril]

blank data means empty data, it's like i have 3 records in the excel but when i finished import process it says i have 12 or more data that have been imported, but actually it only contains 3 records.

please tell me how can i validate?

[comment]

9 minutes ago, Mark Pastoril said:

blank data means empty data

Data can be records or fields. Please use clear and unambiguous terms.

 

10 minutes ago, Mark Pastoril said:

how can i validate?

https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Ffield-validation.html%23

[Mark Pastoril]

i already validate each fields and requires not empty, but still it imports the empty fields.

[comment]

2 hours ago, Mark Pastoril said:

i already validate each fields and requires not empty

But did you select the Validate Always option?

 

[Mark Pastoril]

Already select validate always, it shows errors but still it imports the empty field.

[comment]

I am afraid I don't understand what you are describing. Why don't you post a simple demo that shows the problem?