Forum Discussion

adekunah1's avatar
adekunah1
New Contributor
5 years ago
Solved

Create new column to file

I have sample file ay excel file like below screenshot,

I am trying to add another field or column in the input file in my snaplogic pipeline and look like below screenshot.

Any hints on this?

Thanks in advance.

  • bojanvelevski's avatar
    bojanvelevski
    5 years ago

    Hi @adekunah1 ,

    You can achieve this with a Mapper and the snap.in.totalCount function which counts the incoming documents. Here is the result:

    I’ve attached the sample pipeline below

    Excel - ETL.slp (7.9 KB)

    Regards,
    Bojan Velevski

2 Replies

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    5 years ago

    Hi @adekunah1 ,

    You can achieve this with a Mapper and the snap.in.totalCount function which counts the incoming documents. Here is the result:

    I’ve attached the sample pipeline below

    Excel - ETL.slp (7.9 KB)

    Regards,
    Bojan Velevski

    • adekunah1's avatar
      adekunah1
      New Contributor
      5 years ago

      @bojanvelevski thank you so much. It has helped a lot. I am new to Snaplogic workspace and working on some pipelines.