Profile

Fantastic, thank you so much! Can I ask you another thing please? Its related with output table steps.   I have one fact table and tables around it which are dimensions. The relation is I-N. From Merger Join step I add Table output step, I select the table that I want to create ( the first one is fact ...

Hello Andrew,   Thank you for your answer, it works!!😁 But I have a question just to check. In Merge Join step I put Full Outer in union type. Is it ok? Because If I put Inner It is going to appear just the common rows, and I have different number of rows.   You save my life! Thank you again

Im new in PDI and I would like to create an output Table (my last step to finish ETL) from three different Excels (but with the same primary key), with different columns and different number of rows. The error I have from the system is it cannot do output table procces because of different number of ...