Transfomer with different data source

[madhancog]

Hi ,
  I have created an iqd file in FM and in that one iqd file contains emp id.
  I have one more iqd file that was generated from Impromptu that to contains emp id.
  Is it possible to use these two  emp id from different source in single model and get the data ?
  Pls let me know


KRs,
K.M


 

[vij]

HI madhancog ,
yes you can use that.
In transformer you can use Excel ,iqd,Access tables,csv files as data sources in the same model itself.


regards,
vij
:)

[madhancog]

Thanks for your reply
  My question is when we have 2 emp id one from one iqd and another from next iqd which will be used and how it will work?
Pls let me know


Regards,
K.M

[Mpotla]

Hi ,

suppose u have two files, for the same employee deatils, u can do the Union and show the values from both the IQDs in the same coulumn. U need not to do UNION operation Explicitly, Just keep the same name for the emplyee coulumn in both the iqds, It will automatically do UNION of  the values and shows it in the same field.

Thanks
MC