Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys/girls,
I am loading data from one datasource and wish to perform a left join on a LOAD from a second datasource.
The trouble is, the second data source has three elements that I want to be joined to the first datasource as ONE.
the first of the 2nd datasource is a LEFT JOIN LOAD
the second is a CONCATENATE
and the third is a LEFT JOIN (intending to be joined with the CONCATENATED script)
does this make sense?
I was considering making it a separate qvw and storing as a QVD to read that in - but that seems like making a mountain out of a molehill.
any ideas?
thanks,
Matt