Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
Import data and cumulate it if a data already exist
Hi,
I import data with excel but my problem is that sometimes I have to import a data but there is already a value for it. If I use the palo.setdata function it do not cumulate the new figure with the one that already exist into to database.
for exemple I have a value of 100 for one element into the database and I want to add to this value an amount of 50 to have the final value of 150. With the palo.setdata function it give me 50 and not 150.
Do you have a solution to this problem ??
Thanks in advane for your help.
Didier P.
With SETDATA you can not add. VBA might be an option.
Use ETL Server:
add, update, delete, ...
Hi Didier,
you can use the SETDATA-Function like this:
=PALO.SETDATA(value;FALSCH;"localhost/Demo";"Sales";"All Products";"Europe";"Year";"2002";"Variance";"Units")
Instead of "value" you have to use
PALO.DATAC("localhost/Demo";"Sales";"All Products";"Europe";"Year";"2002";"Variance";"Units")+"Value you want to add (for example value in cell A3)"
So first you look up the existing value and then you add the new value to the existing value.
Hope this helps.
Gerald
Have a look at this thread:
Thread 1023
It helped me. Although, in the end I didn't bother with the offset function. When I import my data the last row gets added twice so I manually type the correct value in. Bit of a pain but only takes a couple seconds.
Jason
