You are here:  » Using the same column twice

Support Forum



Using the same column twice

Submitted by teezone on Thu, 2008-02-07 16:45 in

Hi there, one of my datafeeds is missing brand, but I was able to extract the value using the "DeepLink" field with some specific filters (brand was stored in the URL using /[]/

So I'm basically using the DeepLink field twice: for URL, and also Brand.

The problem is that the filters for Brand somehow also update the URL field during the import process. I tried this a few times, in case I was using the wrong field, but the the filter clearly selects BRAND (DeepLink), not URL (Deeplink).

Is there actually a way to use the same field twice, but only filter one?

Thanks!
T.

Submitted by support on Thu, 2008-02-07 17:45

Hi,

Yes - the filters actually affect the value in the record rather than individually for each registered field. What you can normally do in this instance is to register a blank field as the brand, and then before your manipulation filters copy the Buy URL into it using a Text After filter and the appropriate placeholder, e.g. %DEEPLINK%. After that, it would be safe to use the same filters and they wouldn't affect the actual deeplink.

With XML feeds, there is always a blank record as the containing element (e.g. PRODUCT) is always empty, but it might be more of a problem with CSV, in which case let me know and I'll work something out...!

Cheers,
David.

Submitted by teezone on Thu, 2008-02-07 19:55

Ahhh.. I had looked at using Text After, just didn't know the placeholder step, thanks!!

Everything works perfectly now.

T.