I have something weird going on with my code. I have a Data Extension name “DEXT Seeds”. I am checking the DataSourceName_ to see if this list is picked by a user. I have an if/else statement that says if DataSourceName_ contains Seed, then the variable Seedsource equals “columnSeed” from the local Data Extension. Otherwise lookup Columnsource that matches the subscriberkey from a shared Data Extension.
My issue is that the DEXT Seeds works if I pick a seeded list. But if I pick something outside of the seeded list, I get an error that says it is looking for “columnSeed”. But I don’t want it to pull in ColumnSeed, I want it to lookup Columnsource. Why is it still trying to evaluate columnSeed when it should ignore this code and evaluate the Lookup. Please see the code below.
SET @DEXT = _DataSourceName SET @SubscriberKey = [Customer ID] IF Indexof(@DEXT, "Seed") > 0 THEN SET @Seedsource = [columnSeed] ELSE SET @Seedsource = Lookup('ENT.Shared_DE','Column1','SubscriberKey', @SubscriberKey) ENDIF