Hello

Thank u for your help.

I'll test it tomorrow.

Hello Steve,

This is a screenshot of my Source Table.

And this a Screenshot of Table(Ods.Products)  that I want to populate.

Thank you for your help

• This reply was modified 5 years, 7 months ago by  Lidou123.

Thank you Thom A for your answer

I will test it in this morning

Hello Phil.

Thank you for your answers.

I will be able to clarify my request.

The rules and process for the loading datadata like that:

- we receive an email from another service that...

Data are loaded every night by an ETL from another service.

Hello,

Data are in a sql Server table.

I used excel just for illustrate my issue.

Hello Phil

Thanks for your answers.

- We have 50 tables that could be refreshed. Depending of the day, we receive data for a specific destination table.

So column name could change from...

• This reply was modified 5 years, 7 months ago by  Lidou123.

Hello

Thank you for your answer.

But I want to create a new member in the same column (a calculated member) not a calculated column.

For instance, I want to have in my...

Hello !!

Any idea ??

Is there a way to merge 3 fact table in one ?

In my case I have these 3 Fact Table

1- SurveyFact as

IdDate | IdBrand...

Hello

Thank you for your answer.

Yes there is only a respondent to complete one survey per date period.

I think this design is the best that I could have.

But is there...