Linking a Spreadsheet with a wildcard

[markmccoid]

Not sure if this is possible, but I have a spreadsheet that I would like to link to the data model that would add extra attributes to a table, but I would like to be able to use a wildcard for some of the matching.

For example

Product          Type          SuperType

TDP               REV          CLS

TDP               *                 ROP

So, for Product/Type TDP/Rev show CLS and for all other Types in the TDP product make the SuperType ROP.

This would allow new types to be added to the database without having to update the spreadsheet.

Thanks!!

[JonnyPoole]

What is the field you wish to use to join between the database set and the spreadsheet set.  Is it 'SuperType' ?

You can use the expression logic you laid out to create the SuperType calculated field during the load from the database.  Then if your spreadsheet has matching values,  you can left join or just join the tables together in the load.

[markmccoid]

I would like to link Product and Type.  The SuperType would be the new field.

I would like to be able to have a wildcard in the spreadsheet that would match all Products of TDP that have any (*) Type and add the SuperType field with value of ROP to those.

Thanks