Forum Discussion

harishankarkaim's avatar
harishankarkaim
New Contributor
7 years ago

Unable to connect to My SQL DB hosted in local

I am unable to connect to My SQL DB hosted on Local Machine. Please refer to the attachment.
tstack's avatar
tstack
Former Employee
8 years ago
Copy LinkReport

If you need to drop records, the Filter snap is usually a good option. In this case, you can use the snap.in.totalCount variable to get the total number of records that have been read by the snap. So, to skip the first one, you can use the following for the Filter Expression in the snap configuration:

snap.in.totalCount != 1
  • ptaylor's avatar
    ptaylor
    Employee
    11 months ago
    Copy LinkReport

    Attached is a pipeline to do this mapping. It looks like this:

    First Mapper:

    Second Mapper:

    Hope that helps!

     

     

  • DirkZ70's avatar
    DirkZ70
    New Contributor
    11 months ago
    Copy LinkReport

    Perfect,
    you are a genius 👍
    Your example do exactly what i needed.

    Many thanks,
    Dirk