The ApplyMap() function will help you here.
First you need to create a mapping table
MapEANtoInternalID Mapping Load EAN, InternalID From yourtextfile.csv --In your Load statement //Load *, IF(IDColumn=EAN,ApplyMap(MapEANtoInternalID,IDColumn,Null()),IDColumn) From yoursource.QVD;
That will ensure that where you identify your EAN code, you will map the result to your text file, otherwise, you just use the ID that's already in the source data.
Hope that helps,
Thank you very much George, the result is perfect, the function is really powerfull. I finally have ended, making a left join, with just one table with the exact data I needed, instead of three.
I'm going to put two notes bellow that made some difficult to me:
OLEDB connect [instructions...]
- I wasn't sure where to put the connection... there worked fine.
- It's critical to put the column you are looking for in the first place (obvius )