Developer forum

Forum » Integration » Conditionals not working when column is not mapped with a csv source

Conditionals not working when column is not mapped with a csv source

E-mail notifications
Davy Capiau
Reply
Posted on 30/01/2024 10:09:50

Hi,

DW version: 9.16.3

Problem: conditional filter not working on a not-mapped-column

Source: csv

Example value: "lead"

Destination: DynamicWeb provider - EcomProductUnitOfMeasure

When trying to set a conditional '=' on a non-mapped column nothing happens. On the other hand, when setting a similar condition on a mapped column, it does work.

 

This works:

This doesn't

 

PS:

I also tried quoted, other operators, etc.

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 30/01/2024 17:14:38
Reply
This post has been marked as an answer

Hi Davy,
the not mapped column mappings are treated as not-active so that is why they are not considered, the source values are not read for them and the conditions are also not checked.
Maybe as a workaround you can create a new column in the destination table using sql and then map this not-active source column to the newly created destination column so the mapping becomes active?
Or make a new job that will filter the csv file rows based on all the needed conditions with all columns mapped and then second job will just import the filtered file from the first job without conditions?
BR, Dmitrij

Votes for this answer: 1

 

You must be logged in to post in the forum