Well, with those details only thing I can imagine is that you are not using SORTING and you have activities with the same timestamp (or just with the date part)

HTH

. We uploaded 8 excel files

2. We connected those with the foreign key in the data model

3. We created a new table(_Table1) using the transformation.

4. Did a force complete reload.

5. We created a new package and analysis

6. We made _Table1 as an activity table and added process explorer.

Till this point everything was fine.

After some time, we noticed that the process explorer had no data configured.

So, we checked the _Table1 for the data, the table was empty.

We repeated the same process from scratch, but the process map changed(activity order).

Previously it displayed 135 NULL values in the master table, now it is 107 NULL values(The tables and the transformations remained the same).

Hmmm... here the problem is how was erased that _Table1... maybe you can check in the environment logs to see if somebody inadvertently deleted it.

Said that... if you repeated the same steps with the same data, and you get a different number of items (like different number of null values).... either you are not using the same data or you are not doing the same steps. That's the most logical explanation.

Maybe somebody made some change in the trasnformations or in the original excels?

Otherwise, I'd open a ticket.

Sorry can't help you more.

I understand. Even I thought the same but none has deleted the table. We are using the same data and following the same steps. So couldn't figure it out.

I have raised a ticket to the support team.

I appreciate your time.

Thanks....