Hello All. I am somewhat familiar with VI and have used it for imports and exports.  However, I have something I can not figure out.  Perhaps not possible.

I have a need to dump the entire contents of the IM_AliasItem file to CSV.  Not a big deal.

However, for each line I also need to include warehouse quantity on hand for specific warehouses based on the actual item number (Not the alias).  I understand that this will cause the same warehouse quantities for each alias but we will take care of that after the fact.  In the VI job I was able to create a link from the IM_Alias to the IM_ItemWarehouse file but since the IM_ItemWarehouse file's key is ItemCode+WarehouseCode the lookup does not work.  If I hardcode the warehouse into the key expression like ItemCode+"070" then it does work.  But I need more than one warehouse code and I do not think it is a good idea to hard code like that.  So is it possible to include a wildcard as part of the key expression?  Something like ItemCode+"*" (This does not work).  As I type this I realize this is likely not possible.

But how is the "Sequence number" used in the LINK Table section?  Perhaps I can use that somehow.? 

Basically, I am trying generate a CSV file that contains all of the alias item numbers associated with a Sage item along with the quantity on hand for specific warehouses (I know the quantities will be the same for each Sage Item record).  Note that this is for ALL Alias types (Customer, Vendor and General):

Alias        Sage Item     Quantity       Whse
P1000     B1000                   10           070     << --I know these will be the same since the warehouse QOH is tied to the Sage Item.
P2000     B1000                   10           070     <<-- |
P3000     B1000                   10           070     <<-- |
......

P8000     B2000                     5          070

I know..Kinda messy but just seeing if VI can do this or am I barking up the wrong tree?

Thanks for any info

Becky