Output

Question

Hi,

I have got a scenario where I have few columns with data as indicated in snapshot. There could be records with data to update or it could be blank as seen in snapshot. I only want to identify the ones where there is a value and exclude the blank ones.

For example, for prime key 1003, middle name, title ,phone is blank but remaining columns have data for that prime key so i only
want those columns with data whereas for prime key 1004, most of the columns are blank except a few.
So is there a way to validate each row and column and keep the ones with data and exclude blank ones?

Thank you in advance!

aparna0208 · Answer

@binu_acs No what you said is correct. That's the tricky part. It's in a tabular format and I need to only consider the ones with data and update those records.

binu_acs · Answer

@aparna0208 since your data is in a tabular format you cannot only keep the records having values and remove blank ones.  in your example REP_CRD_C has values for the primary key 10003 and 10032, at the same time the field FIRSTNAME has values for all the primary keys, so how can you keep only two records for REP_CRD_C fields and all records for FIRSTNAME. Am I missing something here?

aparna0208 · Answer

@binu_acs Exactly! So now what's happening is when I do a bulk update for all the records on the spreadsheet, the ones with values are updated and blank ones values causes problem where it blows out the existing value in the source system and changes it from a value to blank. So I'm wanting to have rows and columns that only has values and requires an update