topic Re: Calculated field in App Development

Calculated field

dario_frimel — Sat, 16 Nov 2024 21:48:59 GMT

Hello,

My recent inquires here led me to change my data model and do some changes in tables, I have used calculated fields to simply add some columns that I required for associations. Anyway, I am currently experiencing issue that tables are not being updated from data source which is live SQL database, and each time I load data it goes loading, creating search indexes and goes without errors but nothing gets updated. I am wondering if calculated field prevents tables from updating from source?

Any input on this is highly welcome, thanks in advance!

Re: Calculated field

CathyRDuvall — Wed, 28 Nov 2018 15:59:28 GMT

You may want to consider using the preceding load in your Data load editor to create the calculated fields that you need. If you need to use Dimensions from different tables, best to JOIN tables and use the Resident load to make calculated fields available. No matter which way you do this, make sure to write LOAD *, first to make sure that you are continuing to have the rest of the fields available to you. Good luck.

Orders:

LOAD *,

ProductName - Discount as LineSalesAmount

;

SQL SELECT

OrderID, Sales, ProductName, Discount

FROM [ServerName].TableName

;

Re: Calculated field

CathyRDuvall — Wed, 28 Nov 2018 16:33:03 GMT

If this worked, please show it as Answered or whatever the new version is calling it. Thanks.

Re: Calculated field

jonathandienst — Thu, 29 Nov 2018 06:00:30 GMT

@dario_frimel wrote: I am wondering if calculated field prevents tables from updating from source?

No. But i suggest you post your load script code.

Re: Calculated field

dario_frimel — Thu, 29 Nov 2018 11:36:58 GMT

My data is loaded through data manager so the script is automatically generated, I'll try the above solution today/tomorrow and get back at you guys. I'll try to put script after auto generated locked one, to see if it will work.

Re: Calculated field

CathyRDuvall — Thu, 29 Nov 2018 14:16:42 GMT

I would suggest that you unlock the automatically generated code. Open page which says auto generated and press the lock at the top right hand side. This will allow you to edit the code.

Re: Calculated field

dario_frimel — Thu, 29 Nov 2018 14:24:45 GMT

Wouldn't that cause my associations in data manager to be lost?

Re: Calculated field

CathyRDuvall — Thu, 29 Nov 2018 14:31:55 GMT

No. After you unlock the auto generated code you can save it and then go to Data Model and press "Sychronize scripted tables" at the bottom of the screen. Save and Load Data.
Then go back to Data Editor and add the preceding code.

Re: Calculated field

CathyRDuvall — Thu, 29 Nov 2018 14:35:41 GMT

So sorry... please follow the directions above to load data in the Data Editor from now on, not the Data Model.