DSXchange

Hi,

I am reading a data from a file which has "~" as a delimiter.I am writing to a table.There is column PHONE from source where I have check for null value.I should insert the data only when PHONE is not null.

So I defined a stage variable with condition If IsNull(LK1.PHONE) Then 'N" Else 'Y'.

The constraint I give is StageVar='Y'.Even after defining the constraint,null records are getting populated.Is there any way that I can do this?
But,where the PHONE is null in file holds the data like this :

N-0402~~N~Y~CTR

If there is a value for PHONE then the data look like :

N-7501~462323696~Y~N~CTR

Please remember that an empty string, "", is not null.

Thanks for your response.

So should I have to give If LK1.PHONE="" Then 'N' Else 'Y' condition?

Thanks again

Thanks for your response.

So should I have to give If LK1.PHONE="" Then 'N' Else 'Y' condition?

Thanks again

Concerning telefonnumbers some remarks:

(1) you should check more than "Null" perhaps if at least one number is in it.

(2) There are a lot of formats which differ from region to region in the world.

(3) In some countries and among countries telephone numbers have a different length

(4) Best is to use the international standardize way for numbers like +33-1-2345-3456 for a number in Paris

Thanks a lot !

I will fix it & let you know if I have any issues.

Hi priyaraj,

Y don you try a much simpler solution....

There is no need to use stage variables for this functionality.
Instead check condition in the constraint for the link.

Use this constraint:
not(isnull(required link) )

Thanks .

I will try the code which you have sent & let you know .

Thanks again

SHARAD123 wrote:Hi priyaraj,

Y don you try a much simpler solution....

There is no need to use stage variables for this functionality.
Instead check condition in the constraint for the link.

Use this constraint:
not(isnull(required link) )

Sharad,

I tried using the constraint which You sent ,but it still inserts all the data.Its because of empty string?

SHARAD123 wrote:Hi priyaraj,

Y don you try a much simpler solution....

There is no need to use stage variables for this functionality.
Instead check condition in the constraint for the link.

Use this constraint:
not(isnull(required link) )

You won't be getting NULLs from a text file. The constraint should be

Hi ARVD,


I cannot see your eply as I am not a premium member.Thanks!

No problem, Priyaraj. Someone else might post a non-premium response that will help you soon.

Thanks for your information.I will buy Premium membership if its only 30c per day.Thanks again