Welcome, Guest
Username: Password: Remember me

TOPIC: Is In List Object

Is In List Object 1 month 1 week ago #19639

Hello,

I use Advanced ETL Processor Enterprise (64bit), version 6.3.5.1 and am having issues with using the "is in list" object in the validator. In the properties it is set that when execution result is success to discard record, but instead it writes every single record regardless if it is a success or failure.

I'm trying to only write records to my text file if it is not already in there.


Thanks in advance!
Allison

Please Log in or Create an account to join the conversation.

Is In List Object 1 month 1 week ago #19640

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7748
  • Karma: 33
  • Thank you received: 453
Please post some screenshots so we can see what is going on
Mike

Please Log in or Create an account to join the conversation.

Is In List Object 1 month 1 week ago #19641

Attached are screen shots of the reader, writer and "is in list" properties and text tab. The Reader is the file we are looking at to compare if any of the emails are missing from the provided file in the "is in list text" screenshot.
Attachments:

Please Log in or Create an account to join the conversation.

Is In List Object 1 month 1 week ago #19642

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7748
  • Karma: 33
  • Thank you received: 453
Hi.

1) Your emails may have spaces at the beginning and at the end which you cannot see

Use trim function to get rid of them

2) Also, think about the case sensitivity.

This email address is being protected from spambots. You need JavaScript enabled to view it. is not the same as This email address is being protected from spambots. You need JavaScript enabled to view it.

I cannot see your data or transformation so it difficult for me to point the exact problem.
Mike

Please Log in or Create an account to join the conversation.

Is In List Object 1 month 1 week ago #19643

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7748
  • Karma: 33
  • Thank you received: 453
Please keep us posted on your progress
Mike

Please Log in or Create an account to join the conversation.

Is In List Object 1 month 6 days ago #19646

I made sure the file in my reader, writer and the file I am comparing to in the validator are all tab delimited. All emails are the same case since they come from the same database using the same fields/column headers.

Attached is the transformer.
Attachments:

Please Log in or Create an account to join the conversation.

We have 98 guests and no members online