Copy Data into a Field

Question

Hello guys this might be a silly question but let me explain it

I have a database that looks like this

Customer Code     OrderNumber     Value

000001                    0001             100

000001                    0001

000002                    0002             200

000002                    0002

So i need to put the same information where is blank without losing the other information

Customer Code     OrderNumber     Value

000001                    0001             100

000002                    0002             200

Thank you so much for all your help

Regards

Ivan

IraWatt · Answer

Hey @IvanMtz,

Do you need a SQL query to solve this? By the looks of your example you can use a multi row formula. The formula I used checks if the current value is NULL if so take the value from above else just use the value it has.

If you have any questions make sure to ask :)

HTH,

Ira

Multi row nulls.yxmd

DataNath · Answer

No such thing as a silly question! Would this do the trick? If not, let me know the logic/conditions behind what it can be filled by when you apply it to real data and I'll have another stab!

Fill blank values.yxmd