Data validation

vijaylnyadav

Is there any solution or tool with the help of which I can check if there is any data present or not.

Consider,

file a and file b

If i am uploading both files then there is no error.

if i am uploading only file a then i am getting error at false side,

and if i am uploading only file b then i am getting error at true side.

i am using union before filter so both the files have different column schema and after filter data is not passing but column name is passing with no data.

Please suggest me solution so that i can complete it.

Thanks

JoeS

Hi @vijaylnyadav 

I am slightly unclear on what a successful outcome looks like.

Do you want to output whatever data is there and get no errors if A or B is not there. 

Or would you rather not output either file if only one is there?