Output

[aparna0208]

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!

[binuacs]

@aparna0208 One question the field REP_CRD_C has data in primary key 10003 and 10032 , are you expecting the rest of the blank values for the REP_CRD_C should be removed? 

[aparna0208]

@binuacs 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

[binuacs]

@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]

@binuacs 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.