do not overwrite fields when importing csv

Hello, Thank you all in advance, your topics have been very helpful.

I am new to appsheet and I have a problem importing.

When I import a CSV that has some Rows already in the table. In theory, it updates them, but the fields that do not have information or data in the csv overwrite them with the initial value. even though these fields have values โ€‹โ€‹in the spreadsheet.

example:

Spreadsheet:
key | name | state (initial value: Ready)
111 | John | in progress
112 | Peter | Finalized

CSV file:
key | name
111 | Juan
112 | Pedro
113 | Jesus

Result after import:

key | name | state
111 | John | Ready
112 | Peter | Ready
113 | Jesus | Ready

How could I keep the information?
I already tried adding, to Column "STATE" in the CSV and leaving it blank, but it still overwrites it.

Please help me, Thank you very much.

PS: sorry for my english, use google translator.

 

Solved Solved
0 8 1,088
1 ACCEPTED SOLUTION

Use a branch condition, or separate bots, for it the key exists already or not. In one, add a new record, in the other update the existing.

View solution in original post

8 REPLIES 8
Top Labels in this Space