Abort transform if all rows are empty

[Evren Yamin]

Hello,

I have enabled "copy empty fields" on my transform map. I know this means that all empty values will be copied on the instance.

Thus, is there a way for me to check the value of the columns first and ignore the transform if there is a column where all values are empty on the file being uploaded.

Like for example, in this file, all rows for short desc is empty. I want for the transform to be aborted if the file being loaded is like this one. 

Number	Short Desc	Desc
111		test1
222		test2
333		test3

Appreciate all the help. Thank you.

[Ankur Bawiskar]

@Evren Yamin 

you can query entire import set table and check if all rows are empty but it would be a lengthy logic.

[Komal Gore1]

Hi Evren,

onbefore Transform  script also work, Just try it out first

if (source.short_description.nil()){
ignore = true;
}

[Evren Yamin]

Hello @Komal Gore1, I can try this though since I have a lot of fields on the staging table, I will need to add all of the fields on the condition right? 

[Komal Gore1]

yes , that's right , initially try with one field and less amount of imported data.

like import file with only 10 records , if this worked , you can add all the fields to your condition.

if (source.short_description.nil() ||   source.field_name_1.nil() || source.field_name_2.nil()){
ignore = true;
}