モデル間のインポート

モデルAにある時間形式のラインアイテムをもとに、モデルBからその日付の各製品の在庫数値をインポートするにはどうするのがいいでしょうか。

思いついたのは、、
Bで、Aの日付をインポート
Bで、その日付だけの保存済みビューを作成
Aからインポート

Accepted answers

English:

Importing Between Models

How can we import inventory figures for each product from Model B based on a line item in time format that exists in Model A?

What I came up with is:

If these models are so connected, is there a reason why they are separate? Maybe it’s because of size limits or different locations?

Your solution looks good for now, but it’s worth thinking about how to avoid this situation.

Here are some points to keep in mind:

Avoid real-time imports: Since there are two imports, and data can only be pulled (not pushed) between models, users might need to click two buttons on two different UX pages to run the actions. This can be a bit inconvenient.
Automate the process: If possible, use an integration tool like Cloudworks to schedule the imports. This way, the data can flow automatically without users having to do it manually.

I hope this helps.

Seyma Tas🌷🙂

ありがとうございます。サイズを気にしていました。

考えてみます！！（全部インポートがよさそうです

Moving Sum for Formula driven number format line items
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
Import error due to incorrect time mapping
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import error…
RetrieveTIMESUM using ANY
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…