# Append to JuliaDB tables in a Dict

**URL:** https://discourse.julialang.org/t/append-to-juliadb-tables-in-a-dict/62809
**Category:** Data
**Tags:** question, package
**Created:** [June 12, 2021, 7:49pm UTC](https://discourse.julialang.org/t/append-to-juliadb-tables-in-a-dict/62809 "2021-06-12T19:49:39Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![brett\_knoss](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/brett_knoss/32/13050_2.png) [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)
#### Post date: [June 12, 2021, 7:49pm UTC](https://discourse.julialang.org/t/append-to-juliadb-tables-in-a-dict/62809/1 "2021-06-12T19:49:39Z")

</div>

I have this dictionary on nsparce tables.

```julia
general_ledger=Dict(
		   #:description => ndsparse(date=date, memo=memo),
           :dividends => ndsparse((debit=x, 
			credit=y), 
		(balance=z,)),
		   :expenses => ndsparse((debit=x, 
			credit=y),
		(balance=z,)),
		   :assets => ndsparse((debit=x, 
			credit=y),
		(balance=z,)),
	       :liablities => ndsparse((debit=x, 
			credit=y),
		(balance=z,)),
           :equity => ndsparse((debit=x, 
			credit=y),
		(balance=z,)),
		   :revenue => ndsparse((debit=x, 
			credit=y),
		(balance=z,))
			)

```

and I want to add a new row

```julia
			default_values=Dict(
								"dividends"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)),
								"expenses"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)),
								"assets"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)),
								"libilites"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)),
								"equity"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)),
								"revenue"=>ndsparse((
														debit=[0], 
														credit=[0]), 
														(balance=[0],)))
	
			spec = Dict( 
				credit_account =>ndsparse((
														debit=[0], 
														credit=[credit_amount]), 
														(balance=[0],)), 
				debit_account => ndsparse((
														debit=[debit_amount], 
														credit=[0]), 
														(balance=[0],)))
			modified! = merge!(default_values, spec)
		
			merge(general_ledger, modified!)

```

instead of adding a row to each nsparse table, it creates new entries.