Forum Discussion
jlarques
Helper V
Helper VRecover a field from facttable in another facttable
Dear community, I'm working on two fact tables and I want to recover one field from the table one into the table two. Due that I have many relationships from both tables to dimension tables, the re...
MFelix
Super User
Super UserHi jlarques ,
Can you please share a sample data from both tables and expected result, in order to give the correct result is difficult to do so without the values you have.
I believe that you can use the lookupvalue function however my question is around the Fecha filters you are using.
jlarquesHelper V
Helper VHi MFelix ,
Due to confidentiality I cannot share the table, but this is an extract of what I have in table 1 and what I want to recover in table 2. I hope this can clarify better my problem:
I filtered by "MES" because there are other values, but I'm only interested in this one. I want to recover value by value from table 1 not the result to add both values.
Thanks,